| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need a little help w/ 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" instead of "5" I am getting responses and would like some type of label to go with the number. Thank you!!! |
|
#2
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| countif, again | Excel Worksheet Functions | |||
Linear Mode
