I have attached a file with a sample of the spreadsheet I'm working on. I have shown the 3 formulas that I am trying to write in the spreadsheet to hopefully make it clear what I'm after. I've tried countifs and tried sumproduct but neither appear to be able to cope with counting a range rather than a column.
The 3 formulas required are all counting the cells E2:H15 if they have text
1) if there is a Y in column C
2)if there is a K or an E in column B
3) If there is a Y in columns A or D
I can make it work using countifs and sumproduct if I am just counting one column rather than a complete range but wondering if it is possible to do what I want?
Thanks
Sue xx
Bookmarks