COUNTIF in Sheet Summary

Donni Matthew

I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error.

=COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")

 

Paul Newcome

You need square brackets [ ] around each of your column names.

 

[RESPONSIBLE ENTITY]:[RESPONSIBLE ENTITY]

Andrée Starå

Hi Donni,

When you have columns with numbers or multiple words you have to use Square Brackets.

Try this.

=COUNTIF([RESPONSIBLE ENTITY]:[RESPONSIBLE ENTITY], "FIRM")

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Donni Matthew

Thank you for explaining when the brackets are needed.  I couldn't figure out when/why they were required.  Much appreciated.

Paul Newcome

They are needed when you have a number, space, or special character in the column name. I am pretty sure that covers all of the reasons why you would need square brackets.

Andrée Starå

Happy to help!

Andrée Starå

I always forget about the special characters 

Javier Salar

I'm using the following formula but I keep on getting #UNPARSEABLE

=COUNTIFS({GP TRACKER INTAKE DATE} , IFERROR((@cell),0) > DATE(2019,6,30),({GP TRACKER STATUS}, IFERROR((@cell),0) = "FUTURE PROJECT"))

Frank Falco

Try

=IFERROR(COUNTIFS({GP TRACKER INTAKE DATE} , > DATE(2019,6,30),{GP TRACKER STATUS},"FUTURE PROJECT"),0)

I'm assuming you want 0 if there is an error, based on your IFERROR((@cell),0)

Paul Newcome

@Javier Salar

To correct your original formula, it is just a matter of extra parenthesis being tucked in there.

=COUNTIFS({GP TRACKER INTAKE DATE}, IFERROR(@cell), 0) > DATE(2019, 6, 30) ,{GP TRACKER STATUS}, IFERROR(@cell), 0) = "FUTURE PROJECT")