COUNTIF # INCORRECT ARGUMENT SET
I have a series of cells that aren't continuous, that I Ctrl/clicked into the formula.
I want to count how many are Status N/A.
I can't figure out why I am getting the Incorrect Argument Set error.
=COUNTIF([BV App ID (1) Status]2, [BV App ID (2) Status]2, [BV App ID (3) Status]2, [BV App ID (4) Status]2, [BV App ID (5) Status]2, [BV App ID (6) Status]2, ="N/A")
Comments
-
Based on the rules for using Countif you can only count one criterion at a time.
If you want to count any of those columns with a "N/A" then you would need to create a countif for each column that you want to check.
The following formula should do the trick for you.
=Countif([BV App ID (1) Status]2, "N/A") + Countif( [BV App ID (2) Status]2, "N/A") + Countif([BV App ID (3) Status]2, "N/A") + Countif([BV App ID (4) Status]2, "N/A") + Countif([BV App ID (4) Status]2, "N/A") + [BV App ID (5) Status]2, "N/A") +Countif([BV App ID (6) Status]2, ="N/A")
-
That worked.
Thanks for the help.
Help Article Resources
Categories
Check out the Formula Handbook template!