Adding up weekly totals

  • Thread starter Thread starter alvinuk
  • Start date Start date
A

alvinuk

Hi I'm new to excel and was wondering how to add up the total for each
week, automatically so for example:

Week Number Date Total For Day
42 18/10/2003 31.72
42 17/10/2003 148.64
42 16/10/2003 229.13
42 15/10/2003 276.12
42 14/10/2003 336.01
42 13/10/2003 224.44
41 11/10/2003 58.76
41 10/10/2003 186.23
41 09/10/2003 353.67
41 08/10/2003 210.32
41 07/10/2003 297.26
41 06/10/2003 205.04
40 04/10/2003 103.4
40 03/10/2003 162.73
40 02/10/2003 273.17
40 01/10/2003 205.62
40 30/09/2003 348.14
40 29/09/2003 348.39
... ... ...

That would be part of the table, and for each of the weeks I would need
to add up the corresponding total for days to get the total for the
Week.
 
Looks like you have a data table expanding downward (currently say A1:C100)
With your cursor anywhere inside the table at the menu click on Data,
Subtotals...
and select 1) Each Change in Week Number, 2) Sum 3)Check Total For Day, if
not already checked. then OK
Note the "1,2,3" in the Upper Left corner of your screen; Click on the "2"
object to view the second totaling level; there the system will give you
totals "By Week Number".
HTH
 
Back
Top