Need help w/ easy COUNTIF

  • Thread starter CampFriendNeedsHelp
  • Start date
C

CampFriendNeedsHelp

Hello,

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

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

MALE 5
5


Thank you!!!
 
C

CampFriendNeedsHelp

sorry...it cut off my words, can I have it say Male 5 instead of just a
number for labeling purposes? Is there a way to tell the formula a name/term
to use?

Thanks!
 
D

Dave Peterson

="Male " & countif(...)
is one way.

Another way is to Format|Cell|number tab|custom category:
"Male " #,##0

Then the cell looks pretty, but the value inside that cell is still a number.
 
Top