Sum / countif formula for multiple criteria

[misterjam]

Hi everyone

I am trying to count across 3 columns with multiple criteria in each.

Example attached.

In short, I want to count up if multiple criteria across multiple columns, every formula I have tried so far hasn't worked!

Thanks

[Jdevil]

You might be looking for those instead:
=SUMIFS(
=COUNTIFS(
They use multiple criteria

[Phuocam]

Try this ...

=SUMPRODUCT(1/COUNTIFS(C4:C14,C4:C14,D4:D14,D4:D14,E4:E14,E4:E14))

[TudyBTH]

Hi,
take a look at attachment and says if is what you want