sumproduct with dates
 

Hello,

I was trying to use sumproduct to calculate if column a was a date and
column b was item and column c was a dollar amount so I would know how many
items sold during a specific month and year. It works to calculate the exact
date (7/2/2007 or 7/4/06) but I want it to calculate by month (i.e. all july
07) so I will know how many items sold in a given month and year. Many thanks.
--
Jake

sumproduct with dates
 

=SUMPRODUCT(--MONTH(A1:A100)=1,.....)
will test that the month of the dates in A1:A100 is 1 (January - for most of
us)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jake" wrote in message
...
Hello,

I was trying to use sumproduct to calculate if column a was a date and
column b was item and column c was a dollar amount so I would know how
many
items sold during a specific month and year. It works to calculate the
exact
date (7/2/2007 or 7/4/06) but I want it to calculate by month (i.e. all
july
07) so I will know how many items sold in a given month and year. Many
thanks.
--
Jake

sumproduct with dates
 

Please do not post separately to more than one NG - most of us read them
all.
Answered in .newusers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jake" wrote in message
...
Hello,

I was trying to use sumproduct to calculate if column a was a date and
column b was item and column c was a dollar amount so I would know how
many
items sold during a specific month and year. It works to calculate the
exact
date (7/2/2007 or 7/4/06) but I want it to calculate by month (i.e. all
july
07) so I will know how many items sold in a given month and year. Many
thanks.
--
Jake