="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.
CampFriendNeedsHelp wrote:
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!
"CampFriendNeedsHelp" wrote:
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!!!
--
Dave Peterson
|