Totals by Class and Week

[chimp]

i need to total data in my spreadsheet, which will alsways be stored i
the same way but i will be pasting in the data each day into th
column.

the number of rows of data will be changing each time i paste the dat
in, each time i paste my data into the spreadsheet i will be emptyin
the current data out first and then pasting in the data into Cell A
onwards.

I have attached my spreadsheet for you to see:

PROBLE

what i want to do is:

for each class A,B or C total the stock in cases but this needs to b
grouped by the weeks stock.

so if the *Weeks of Stock* is between 0 and 1 weeks inclusive the tota
of the stock for each class will be totalled in the grid to the right o
my spreadsheet.(highlighted in Blue)

please help

And

+-------------------------------------------------------------------
|Filename: totals by class.zip
|Download: http://www.excelforum.com/attachment.php?postid=2691
+-------------------------------------------------------------------

 

[Frank Kabel]

Hi
not looking at your attachment maybe a pivot table is what you're
looking for:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm