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
