Need help w/ easy COUNTIF
 

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!!!

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!!!

="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