Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|