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.
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.