SUMIF Question
 

Hi,

I have a spreadsheet which lists Sales and dates that those orders are to be
delivered on. These dates do not run consecutively on the spreadsheet though.
I want to produce a formula that will add up the volume of all orders from a
set date (First day of the month) up to todays date + 1 (Tomorrow) So at any
time in the month I have a figure that shows the volumes of all orders
delivered up to tomorrow.

SUMIF Question
 

How about where col a is your dates and 4 is April and col B is the values
to add.

=sumproduct((month(a2;a22)=4)*b2:b22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark" wrote in message
...
Hi,

I have a spreadsheet which lists Sales and dates that those orders are to
be
delivered on. These dates do not run consecutively on the spreadsheet
though.
I want to produce a formula that will add up the volume of all orders from
a
set date (First day of the month) up to todays date + 1 (Tomorrow) So at
any
time in the month I have a figure that shows the volumes of all orders
delivered up to tomorrow.

SUMIF Question
 

Presumably colon, not semi-colon ?

=sumproduct((month(a2:a22)=4)*b2:b22)
--
David Biddulph

"Don Guillett" wrote in message
...
How about where col a is your dates and 4 is April and col B is the values
to add.

=sumproduct((month(a2;a22)=4)*b2:b22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark" wrote in message
...
Hi,

I have a spreadsheet which lists Sales and dates that those orders are to
be
delivered on. These dates do not run consecutively on the spreadsheet
though.
I want to produce a formula that will add up the volume of all orders
from a
set date (First day of the month) up to todays date + 1 (Tomorrow) So at
any
time in the month I have a figure that shows the volumes of all orders
delivered up to tomorrow.