Combining multiple criteria in COUNTIFS formula

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

There seems to be an error in my formula.  The first part works by itself (counting the number of times the SME's name appears).  Then, when I add the critieria to limit the count to those whose status is "Red", I get an "incorrect argument" error.  It is selecting the correct data sets to pull from.  Please look at my formula and tell me if you can identify a missing comma, parenthesis, or operator.  The formula is:

=COUNTIFS(SMEA:SMEC, = "Jane Doe", Status:Status, = "Red")

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!