Cannot CountIf from a Formula Column

Leah Brown
Leah Brown ✭✭
edited 04/05/22 in Formulas and Functions

Hey everyone,

I have a column that has a vlookup function to produce an out of a region name such as Americas. I want to summarize the count that has Americas as the output in the Sheet Summary tab. However, when I use the countif formula, I receive a No Match even though I know I have regions of Americas. This was working 2 weeks ago so not sure what changed any help would be appreciated.

I have confirmed there are no typos.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!