Hi,

Does anyone know the formulae for counting certain text from a drop-down
list in excel?

I have used all the different COUNT functions i can try and the only one
that was close was COUNTIF but it would not count the drop down list of text,
only the text I wrote into the cell.

Can anyone help!

Thanks, Em