To count H's in col. B:

=COUNTIF(B:B,"H")

HTH
Jason
Atlanta, GA

-----Original Message-----
We sent out a survey and I need to make a database to
enter the results. I
don't want to use Access. Some of the responses are H,
M or N and I need a
formula that will allow me to find out how many H's, M's
and N's are in the
sheet for each question.

Any suggestions?

THANKS!
--
Richelle
.