COUNTIF # INCORRECT ARGUMENT SET

alexanderc47046

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

Mike Wilday

Based on the rules for using Countif you can only count one criterion at a time.

• https://help.smartsheet.com/function/countif

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

 

alexanderc47046

That worked.

Thanks for the help.