Help with unparseable COUNTIFS

Anita Darling

Here is the current unparseable formula which isn't working; any help is much appreciated:

=COUNTIFS([CATEGORY]:[ CATEGORY], "Criterion1", [[TOPIC]:[ TOPIC], "Criterion2"])

Mathieu PERSICO

Hi Anita,

Remove the brackets in your second argument:

=COUNTIFS([CATEGORY]:[ CATEGORY], "Criterion1", [TOPIC]:[ TOPIC], "Criterion2")

You are welcome!

Mathieu PERSICO

Hi Anita,

Remove the brackets in your second argument:

=COUNTIFS([CATEGORY]:[ CATEGORY], "Criterion1", [TOPIC]:[ TOPIC], "Criterion2")

You are welcome!

Anita Darling

Thank you, Mathieu! The suggestion in Smartsheet has brackets shown, so I was using the same syntax.

Paul Newcome

@Anita Darling The brackets in the example are there to show that the additional range/criteria are optional meaning you don't need them for the COUNTIFS to work. The example itself at the top of the "help box" shows without.