Weekly Total ????

[natei6]

Hello to All,

I have a list of daily customer orders. Column A is name of customer, Column B is Date and Column C is number of pieces ordered. I have a daily running total in Column D, how do I create a weekly Running Total with the week starting Monday and Ending Friday?
Regards,
Nathan Sargeant

TIA

[olasa]

Try this:

Customer.......Date.........Pieces.....RunTot
Adam.............03/04/05..11............=C2
Bob................03/04/05..5..............=IF(WEEKNUM(B3,2)>WEEKNUM(B2,2),C3,C2+C3)
Copy down the formula

It will look for a weeknum greater then the previous. If so start a new RunTot otherwise continue sum the running total.

Ola Sandström

[natei6]

Hello to All,

I have a list of daily customer orders. Column A is name of customer, Column B is Date and Column C is number of pieces ordered. I have a daily running total in Column D, how do I create a weekly Running Total with the week starting Monday and Ending Friday?
Regards,
Nathan Sargeant

TIA

Try this:

Customer.......Date.........Pieces.....RunTot
Adam.............03/04/05..11............=C2
Bob................03/04/05..5..............=IF(WEEKNUM(B3,2)>WEEKNUM(B2,2),C3,C2+C3)
Copy down the formula

It will look for a weeknum greater then the previous. If so start a new RunTot otherwise continue sum the running total.

Ola Sandström

Thanks, I think I'm on the right track, but I need to clarify a little bit.

My running total starts over everyday...... =IF(B3=B4,D3+C4,C4)

The next Column Is a Total For The Day...... =IF(B4<>B3,D4,"")

So I need Column F to total Monday thru Friday

Thanks again

Nathan