Formula?

[Kathy]

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.

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a"))

 

[Kathy]

Thank you peo. What do the --'s signify?

One way

=SUMPRODUCT(--(B2:B100="c"),--(C2:C100="a"))

 

[bj]

they change the logical true false to numeric 1 0

 

[Kathy]

Thank you.

they change the logical true false to numeric 1 0