excel date ranges
 

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.

excel date ranges
 

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.

excel date ranges
 

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.

excel date ranges
 

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.

excel date ranges
 

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.