Does anyone have any ideas on how to calculate data that is listed by date
(not necessarily in date order. I am trying to come up with a week ending
subtotal in a summary sheet from a number of different worksheets. My data
is listed as shown in each worksheet. If anyone could offer a formula to
put in my summary sheet it would be greatly appreciated.

Column b Column I
Date Net weight in tonnes
3/09/2007 37.5