Countif Multiple Column?

[CraigMcKee]

Hi,

I would normally just use a countif to total how many correct answers there were in a particular question, e.g. countif(B:B,"Correct") and this would work perfectly but what if I wanted to count how many Boys got the question correct so that would mean column A would need to read Boy AND column B have the word "Correct" in.

Can I achieve this using something like Countif?

[JohnTopley]

Look at COUNTIFS

[Phuocam]

Use Countifs() function:

=Countifs(A:A,"Boy",B:B,"Correct")

[davsth]

yes countifs! Its the same logic with mutliple criteria

[samba_ravi]

=Countifs(A:A,"Boys",B:B,"Correct")

[CraigMcKee]

- definitely not embarrased!! Thank you! So simple.