Have a look at using
Datafilterautofilterdatecustom

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Skibee" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Skibee" wrote in message
...
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.