COUNTIF

New Contributor

Hi 

I have created a drop down menu with 3 options yes no future or can be left blank. If one of my colleagues selects one of the 3 options i want to count that towards the total.

I have managed to get the total before when only counting "Yes"  by using COUNTIF(A1:A10,"Yes") but i cant figure out how to add No and Future to that formula.

could someone help?

thanks
Drew

2 Replies

@DrewDickson91 

If you want to count all non-blank cells:

=COUNTIF(A1:A10,"<>")

Or, since the options are text values:

=COUNTIF(A1:A10,"*")

@Hans Vogelaar  that worked thank you very much for your help