Count across multiple columns with two critera

**ucirsharma** · 02-20-2013, 12:50 PM

Hi everyone, first time user here... I have a question about what would be the best way to count across multiple columns taking into acount 2 criteria. I have searched and searched on this and can't find anything about counting across columns.

So the situation is that I have an attendance summary sheet, which accumulates data from 26 pay period attendance sheets. The way it currently accumulates is like so:

Week --> 1 2 3 4 5
Months--> January January January January February

Monday ESL ETV
Tuesday ESL
Wednesday
Thursday HOL HOL
Friday
Hours 80 72 80 72 72

Monday
Tuesday
Wednesday ETV HOL ESL
Thursday
Friday
Hours 80 72 80 72 72

I need to count up all the individual values (HOL, ESL, ETV) for each month. I tried to do a countifs and even a sumproduct across the range looking for the values (HOL, ETV, ESL) and the month, but that did not work.

Help please!

**Pepe Le Mokko** · 02-20-2013, 01:06 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**ucirsharma** · 02-20-2013, 01:16 PM

The first sheet is the summary sheet, the second is where I am trying to count up the values (ESL, ETV, HOL)... you can see my futile attempts to come up with a formula.

**ucirsharma** · 02-20-2013, 01:26 PM

The first sheet is the summary sheet, the second is where I am trying to count up the values (ESL, ETV, HOL)... you can see my futile attempts to come up with a formula.