| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula?
I have a spreadsheet with 2 questions with answers in columns b & c. What
formula do I enter to return how many people entered both of the correct answers of c and a? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula?
One way
=SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a")) -- Regards, Peo Sjoblom "Kathy" wrote in message ... I have a spreadsheet with 2 questions with answers in columns b & c. What formula do I enter to return how many people entered both of the correct answers of c and a? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula?
Thank you peo. What do the --'s signify?
"Peo Sjoblom" wrote: One way =SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a")) -- Regards, Peo Sjoblom "Kathy" wrote in message ... I have a spreadsheet with 2 questions with answers in columns b & c. What formula do I enter to return how many people entered both of the correct answers of c and a? Thank you. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula?
they change the logical true false to numeric 1 0
"Kathy" wrote: Thank you peo. What do the --'s signify? "Peo Sjoblom" wrote: One way =SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a")) -- Regards, Peo Sjoblom "Kathy" wrote in message ... I have a spreadsheet with 2 questions with answers in columns b & c. What formula do I enter to return how many people entered both of the correct answers of c and a? Thank you. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula?
Thank you.
"bj" wrote: they change the logical true false to numeric 1 0 "Kathy" wrote: Thank you peo. What do the --'s signify? "Peo Sjoblom" wrote: One way =SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a")) -- Regards, Peo Sjoblom "Kathy" wrote in message ... I have a spreadsheet with 2 questions with answers in columns b & c. What formula do I enter to return how many people entered both of the correct answers of c and a? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
