Column selection for Sheet Summary formulas?

SMacey

Hi Everyone,

I am trying to select a row for a sheet summary formula, but it keeps giving me an #UNPARSEABLE error. It is working fine for other columns - however I notice on the ones where it is working the column range is linked, but not for the one I am having an issue with.

Here is the one that is not working:

Here is the one that is working as expected:

For the formula where I am getting the error, I clicked a cell in the column, so I know the column spelling is correct, so why is it not picking up the column like it did for the Region column? Is there another way to select the entire column for a formula?

Thanks in advance!

Andrée Starå

Hi @SMacey

I hope you're well and safe!

Try something like this.

=COUNTIF([IDEAS BUNDLE]:[IDEAS BUNDLE],"Franchised")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @SMacey

I hope you're well and safe!

Try something like this.

=COUNTIF([IDEAS BUNDLE]:[IDEAS BUNDLE],"Franchised")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

If there is a space, number, or special character in the column name, you have to wrap the column name in [Square Brackets].

[IDEAS BUNDLE]:[IDEAS BUNDLE]

SMacey

Ah ha! Learn something new every day! Thank you so much @Andrée Starå and @Paul Newcome that worked!

Andrée Starå

@SMacey

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Happy to help. 👍️