Formula
 

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.

Formula
 

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.

Formula
 

Hi Pranav:
Thanks for your help, though I was probably not very clear. What I need
first is to identify those right answers, so the first thing that my formula
has to do is to compare each card with the one with the right answers (and
after that, give me the results for each card).
Any thoughts?
thx

"Pranav Vaidya" wrote:

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.