COUNTIFS Is It possible to count multiple columns?

[Gollum9]

I have a spreadsheet (image attached), where I'm looking to do a COUNTIFS if a person has a particular site and manager. If they do, I want to count the number of "Y" and "Yes" in all of the columns headed A thru E.

I've tried a regular COUNTIFS formula but if the count range is columns E:I and not just one column, I get a VALUE error message.

Is this possible? Is COUNTIFS the wrong formula to be using?

Many thanks for your help.

 

[RoryA]

All the ranges in COUNTIFS need to be the same size. You can use SUMPRODUCT instead.

 

[Gollum9]

All the ranges in COUNTIFS need to be the same size. You can use SUMPRODUCT instead.

Ok thanks, let me take a look into that option