If your answers for 10 questions are in 10 columns
=SUMPRODUCT(--(A1:J2000="H")) in some cell on your sheet.
-----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
.
|