Need a little help w/ COUNTIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=IF(COUNTIF(A1:A20,"Sandy")>0,"MALE "&COUNTIF(A1:A20,"Sandy"),"")

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Countif function 1
Finding the weighted average of text that have been given values 1
countif OR function 5
Countif gone wrong 2
Combination of IF, AND, and COUNTIF; need help 6
Need Help FAST with COUNTIF Formula 0
Sumproduct not working 5

Back
Top