View Single Post
  #5   Report Post  
GerryK
 
Posts: n/a
Default

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
.