COUNTIF Formula Help

Dana A

Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column says CLOSED.

 

This is the COUNTIF formula I'm using now:

="NAME (" + COUNTIF([Lead]:[Support], "NAME") + ")"

 

It gives me a count of 7, but if I can get it to look at the Stage column and not count if it says CLOSED, I should get a count of 4. 

 

Any help would be appreciated.

Shaine Greenwood

Hi Dana,

 

You might try using the NOT function in your COUNTIF formula. You may need to use a COUNTIFS formula if you need the formula to meet multiple conditions.

 

Details on this are available in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas

Dana A

Thanks for the help Shaine, I'll see if I can figure it out using the information you provided.