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.
|