Countif acting funky.

Gnalen

I have a working countif formula that works for some variables and not others.

I have a helper sheet that has the columns to count the occurrences of words in a column, from a drop down list

NPD

Sust

New Cust

PPV

VAVE

So from my helper sheet I have the formula: =COUNTIF({Type Of Project}, ="NPD"), which looks at my main data sheet in that range.

My issue is it returns 0 when I put PPV or VAVE into the formula?

Thanks for any help.

Gary

Gnalen

I sorted it out…. I was referencing a backup sheet instead of the current one.