countif errors

[lhaitken]

ok have a sheet that is smart filtered by a equiments location. and the b collum is data validated with a drop down box. I am trying to make a countif formula to count the number of equipment at the possible locations. should be something like this
=countif(b3:B62,FRH)
=countif(b3:B62,VIC)
=countif(b3:B62,SHN)
=countif(b3:B62,QUL)
=countif(b3:B62,LAV)
=countif(b3:B62,INSPEC)
all of these are returning 0. is there a problem with the formula or are the drop downs messing with the formula? Thanks
-Larry

 

[Mel Smith]

Hello Larry,

Try putting the criteria in quotes, e.g. =countif(b3:b62,"FRH")

Mel

 

[lhaitken]

Hello Larry,

Try putting the criteria in quotes, e.g. =countif(b3:b62,"FRH")

Mel

how i didnt catch that i don't know but thanks!