sumproduct for month and year
 

Hi,

I am trying use sumproduct to add totals for a month when the criteria or
date column is in the date format mm/dd/yyyy.

For example the month column could have the following dates

06/04/2006
06/17/2006
06/21/2006
07/12/2006
07/18/2006
08/16/2006
08/24/2006
08/31/2006

I need to get the totals for the month 06/2006, 07/2006, and 08/2006

Thanks for your help.
--
Benjamin

sumproduct for month and year
 

=sumproduct(--text(a1:a100,"yyyymm")="200606"),b1:b100)

Adjust the range, but don't use the whole column.



Benjamin wrote:

Hi,

I am trying use sumproduct to add totals for a month when the criteria or
date column is in the date format mm/dd/yyyy.

For example the month column could have the following dates

06/04/2006
06/17/2006
06/21/2006
07/12/2006
07/18/2006
08/16/2006
08/24/2006
08/31/2006

I need to get the totals for the month 06/2006, 07/2006, and 08/2006

Thanks for your help.
--
Benjamin

--

Dave Peterson