COUNTIF for specific text from drop down list

[Leehartnell]

Is it possible to create a formula to calculate how many cells contain specific text that has been selected from a list?

eg

Cell A2 can be user selected to be either 'Not Actioned', 'In Progress' and 'Complete'. I want to be able to display the number of all the complete selections

 

[bellman101]

Hi Lee,

Not 100% on what you're trying to do,

but I'm guessing it is one of these:

=COUNTIF(A:A,"Complete") - will count how many times "Complete" appears in column A.
Or
=COUNTIF(

#VALUE!

 

[Leehartnell]

Yea i've tried that first one but it doesnt seem to work. In this case, each row in column A is from a drop down list. But when I select Complete from the drop downbox it doesnt change the cell with the countif formula in

 

[bellman101]

Is it just a data validation drop down?

put =A2 in a cell.
Copy that cell.
Pick another cell and paste special => paste values.

Check the cell in the formula bar. are there any leading/trailing spaces?
If so, sort them out in the validation list, or try

=COUNTIF(A:A,"*Complete*")

Cheers
JB