Countif Text with Excel Table Nomenclature

[csenor]

Good afternoon,

I have a basic excel table that I made using Control + T. I'm using a countif formula outside of the table to count a specific word in a column. My formula is returning a 0 instead of the actual count. What am I doing wrong?

Both formulas below did not work.

Formula: =countif($f6:$f150,"Active")

Formula: =countif(Table1[MemberType],"Active")

 

[Fluff]

Make sure there are no leading/trailing spaces

 

[alansidman]

If Fluff's answer does not solve the issue, then use XL2BB to post some sample data for us to investigate.