CountIF not returning expected value

Louis Martinez

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: https://app.smartsheet.com/sheets/59wgCjQqwPQ6jrFxH9RfVM6gpC2gQ93JP97GGhF1?view=grid

The metric sheet is https://app.smartsheet.com/sheets/cpJv57hrhGH99Xfvqhxj8M6rPGwm55Gw9Wq5RMW1?view=grid

Andrée Starå

Hi @Louis Martinez

I hope you're well and safe!

Thanks! I'll take a look and get back to you!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Louis Martinez

It seems like you've solved it already.

It should look something like this

=COUNTIF({EMEAR Tiger Team Exec Engagements H2 Range 2},<> "")

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!