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.