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.