Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!! |
#2
|
|||
|
|||
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!!! |
#3
|
|||
|
|||
="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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EASY ONE ! using countIF.. puzzled | Excel Discussion (Misc queries) | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |