Using CountIF function to calculate Count of Market

Hi! I'm looking to get some help on a CountIF formula. I have a sheet "Territory 4 Exit Interview Pivot Table" which I am looking to get a count of how many employees are in Market 41, 42, 43, and 44 (from the T4 Exit Interview Results sheet screenshot). I keep getting all sorts of errors when trying to use the CountIF formula.

One thing to note is that the Market is populated with a V Lookup Formula, coming from this other sheet (V Lookup list for market and district). Not sure if that is the reason of the error.


Would love if someone could advise on this CountIF formula.


Thank you!


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!