COUNTIF in Sheet Summary

Donni Matthew · 10/31/19

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 · 10/31/19

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

[RESPONSIBLE ENTITY]:[RESPONSIBLE ENTITY]

Andrée Starå · 10/31/19

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 · 10/31/19

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

Paul Newcome · 10/31/19

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å · 10/31/19

Happy to help!

Andrée Starå · 10/31/19

I always forget about the special characters

Javier Salar · 03/09/20

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 · 03/09/20

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 · 03/10/20

@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")

COUNTIF in Sheet Summary

Comments

Help Article Resources

Categories