CountIF not returning expected value

Using an Countifs to look at a column called Account and count if not blank. The formula using is =COUNTIF({EMEAR Tiger Team Exec Engagements H2 Range 2}, "") . Expected count is 38 and returns 12.

The sheet being referenced is:

The metric sheet is


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!