Using the OR function within a count formula referencing another sheet

Anna Keeton

Hey all,

Trying to work out how to add in the OR function to a count formual referencing another sheet.

Presently I've got.....

=COUNT(COLLECT({Activity}, {Row Type}, "Parent", {Status}, "Delayed"))

But the Status could be any of "Delayed", "In Progress" or "Client Delay"

Any help much appreciated!!

Thanks, Anna

Mark Cronk

Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.

Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))

If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.

Work?

Mark

Mark Cronk

Hi @Anna Keeton ,

Try:

=COUNTIFS({Activity}, ISTEXT(@Cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))

Mark

Anna Keeton

Hey Mark - sadly I'm still getting unparseable with that :/. Thanks though!

Any other ideas?

Mark Cronk

Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.

Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))

If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.

Work?

Mark