Try:

=IF(COUNTIF(A1:A20,"Sandy")0,"MALE "&COUNTIF(A1:A20,"Sandy"),"")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"CampFriendNeedsHelp" wrote
in message ...
Hello,

I have a formula to calculate COUNTIF on a data range.

MY QUESTION: Is it possible to have the cell say:

"MALE 5" instead of "5"
I am getting responses and would like some type of label to go with the
number.


Thank you!!!