COUNTIF # INCORRECT ARGUMENT SET

alexanderc47046
alexanderc47046 ✭
edited 12/09/19 in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

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

     

    · Share on FacebookShare on Twitter
  • alexanderc47046
    alexanderc47046 ✭

    That worked.

    Thanks for the help.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!