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.
