I have a spreadsheet that looks like the following:
--------A---------B----------C-----------D----------E--------F-----------G----------H------------I---------J
1--TimeMon--TimeTues--TimeWed---TimeThurs---TimeFri---MonMode---TuesMode--WedMode---ThursMode--FriMode
2--9:00 am---9:00 am----5:00 am---10:00 am---11:00 am-----A-----------A---------A------------M---------M
3
4
I need to count all instances "where TimeMon is between 6 am and 10 am and MonMode = A", "where TimeTues is between 6 am and 10 am and TuesMode = A", etc. for all rows in the spreadsheet.
I can handle "between 6 am and 10 am" and using countif to count all "MonMode=A", but I can't wrap my head around counting all instances where the two criteria are true for Monday - Friday for all rows.
Can this be done?
Bookmarks