Oct 15 2021 02:32 AM
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
Oct 15 2021 03:28 AM
If you want to count all non-blank cells:
=COUNTIF(A1:A10,"<>")
Or, since the options are text values:
=COUNTIF(A1:A10,"*")