Calculate total based on Employee Name for all entires in a given month

[andrewithaca]

Hi all, I've seen some solutions that get close but have not had any luck. I have a sheet for managing client budgets that I use as a base template and duplicate for each client. I often have to add employees through out the year.

This is where I log each employee's time for a specified date range.
Screen Shot 2020-12-21 at 11.46.13 AM.png

What I'm looking to achieve is a formula that can go in a summary table B2:M6 below that totals all values for each person for that Column's month. In layman's terms, sum all entires that match "B1" (month) AND "A2" (employee name).

Screen Shot 2020-12-21 at 11.46.55 AM.png

I've attached a sample sheet. Please help!

[Pepe Le Mokko]

Your sheet does not contain data to work on...

[andrewithaca]

DELETED still getting used to this

[andrewithaca]

Your sheet does not contain data to work on...

Are you seeing something different from the attached images? The sheet I uploaded has two tabs, one for hour entries the other for the summary. Happy to include more, just not sure what else to include?

[Pepe Le Mokko]

Sorry your data was in the first columns which I didn't notice

[andrewithaca]

Sorry your data was in the first columns which I didn't notice

No worries at all! I appreciate any and all help. C2:H53 on the first sheet is where I put in all of the hours. Columns A and B don't change, but I often add columns for additional people (i.e. "Person 6) to track their time. On the "Monthly Totals" sheet, B2:M6 is where I'd like the formula to live.

[Exl-Noob]

Hi andrewithaca,

Seems like its a work that can either be done by SUMPROD() or SUMIFS().

here is the rendering with SUMPROD(). Example of formula in B2 :

Please Login or Register  to view this content.

I strongly suggest you change the way you handle dates to a switch to real dates instead of text.
That can be done by

• Inserting a column with January first as first date, then refering to this date +7 days for the following cells.
• extracting the week with the appropriate excel formula.
• displaying the date in your MonthlyTotals by inserting 01/01/2020 and setting the "mmmm" format instead of the text "January"
• refering to the starting date and EOMONTH(startingdate,0) in the SUMPROD formula.

Enjoy.