Sum weekly & monthly totals

Are your days always mixed around like that, such that you dont always have an entry on Sat or Sun?

Hi jojo,

I've added two helper columns to your table that allow the answers to be like you want. See the Week Num and Month Num columns added and see their formulas. Then look at the weekly totals and monthly totals formulas and confirm they are correct.

Thanks for the assist Marvin

Sample%20weekly%20totals(1).xlsx

Looks Like I did the same as Marvin. Haven't check our results are the same - just noticed you used two helpers columns too

Throwing this one in here as an after thought -

When you are building out logs of data like it appears you are doing... I highly recommend doing so as an individual record and then making reports based off of that log instead of trying to build a Log as a report.

Columns Date, User/Employee/Agent etc..., and Amount are the only 3 you need, Then a formula to dictate what the week number is so your log technically is never more than 4 wide. Now being that this is a time based report that you are compiling and you are looking to display a form of earning, I then would recommend going with a pivot table! In a pivot table you can group on dates to allow seamless reporting of time such as year, quarter, month, date down to time even. They don't build in week which is why I still would add that to your log... Then throw it into that pivot table. You are in 2010 Excel so you can also take advantage of Slicers! Basically a fancy filter that visually will help you navigate through the layers of data you are producing. Here is a sample out of your data of what I mean...

Data.xlsx

Cheers!