Add weekly totals

[Spook2000]

Hey Guys,

I have a machine that its operational hours are logged. Very simple table of column A is the date the machine was used and column B is the hours it was used. There may be some days it was not used and some days with multiple entries. What i'd like to do is to have a formula that will add up the weekly totals the machine was used.

Help much appreciated, Thanks

[BanginMyHeadOnMyDesk]

Put the week commencing date in a cell (for this example I've used E3) then put the below formula in the cell to its right.

=SUMIFS(B:B,A:A,">="&E3,A:A,"<="&E3+6)

In E4 put

=E3+7

Then copy the SUMIF formula down to D4.

You can then copy both formulas down for as many weeks as you need.

Beth.

[Spook2000]

Awesome! Thanks Beth!

[BanginMyHeadOnMyDesk]

Happy to help

Beth.