|
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com