Maybe with dates in column A and tonnages in column B
Start date in C1 and end date in C2

=SUMIF(A1:A100,"="&C1,B1:B100)-SUMIF(A1:A100,""&C2,B1:B100)

Mike

"Skibee" wrote:

I have a spreadsheet recording wheat coming into various stores for a number
of customers. All wheat coming into store is entered on one sheet and this
then fires through to the relevant store worksheet eg store 1, store 2 etc.

Under a column headed €˜date the date on which the wheat came into store is
recorded. I would like to be able to ask the database what wheat came in
between two date ranges eg. Between 01/07/07 and 31/07/07 and so on for each
month.

The records are not necessarily entered in date order as entries are made as
the paperwork hits the office.

Many thanks for any help.