if your data is spread across range A1 to C15, then use this -

=COUTNIF(A1:C15,"right")

you can use your criteria instead of "right".
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"dardiaca" wrote:

Hi:
I'm doing something which resembles comparing punched cards or grading
multiple choice exams.
Each card has three columns with only one possible punch and 15 rows.
I need to count the amount of punchs that coincide with the "right" one and
sum the right answers.

What function should I use?
Thanks
D.