excel date ranges

[Guest]

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.

 

[Guest]

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

 

[Don Guillett]

To sum for Jul
=sumproduct((month(a2:a22)=7)*b2:b22)

 

[Guest]

Thanks for that. I don't need to add up the total tonnage of wheat that came
in. I need Excel to display the entirety of each record pertaining to wheat
received in the relevant month.

So that would be date wheat came into store, customer for whom it is being
stored, wheat variety, field it came from, ticket number of load, all the
moisture details, bushel weights, drying charges etc.

So the date is column A, customer column B, store C, variety D, field E,
ticket no F, etc. with headings up to column M.
Is this possible?

 

[Don Guillett]

Have a look at using
Data>filter>autofilter>date>custom