Formula in Excel--SUMIF

[Guest]

I have results from surveys we sent out and I need to make a database of the
results. I am more familiar with Excel than Access. We have questions that
the responder selected an answer of H, M or N. I need to be able find a
formula to find out how many H's, M's and N's there are once the database has
been entered.

Any suggestions!

THANKS!

 

[JulieD]

Hi Richelle

try COUNTIF instead of SUMIF
e.g.
=COUNTIF(A1:A1000,"H")

Cheers
JulieD

 

[JulieD]

Hi

i also notice that you received a large number of replies in
microsoft.public.worksheet.functions

please don't ask the same question in different groups as most of us who
respond to questions read a number of groups and all it does it fragment
your answers and annoy people who may have spent time working on an answer
only to discover that it has been answered in another group.

Cheers
JulieD

 

[Guest]

Thanks for the response. Sorry the double posting caused a problem, but I
found the worksheet function newsgroup after I'd posted this one.

 

[JulieD]

no problems ... just a note for future ref