New Contributor


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?


2 Replies


If you want to count all non-blank cells:


Or, since the options are text values:


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