Hi Richelle

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

Cheers
JulieD

"Richelle" wrote in message
...
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!
--
Richelle