Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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".
 
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
 
Back
Top