adding next years value

[tleehh]

i would like to add all the values in month of january of 2010 in colume D.
i am using formula as follows but does not add.

=sumproduct(d10:d100,--(month(b10:b100)=month(now())+2,--(year(b10:b100)=
year(now())+1))

colume B contains a dates and colume D cotains value.

Thank you.

 

[Dave Peterson]

Are you really asking to sum the values for dates two months from now?

So on Jan 13, I'd want March -- of the same year?

if yes:

=sumproduct(d10:d100,
--(text(b1:b10,"yyyymm")
=text(date(year(today()),month(today())+2,1),"yyyymm")))

 

[tleehh]

Are you really asking to sum the values for dates two months from now?

So on Jan 13, I'd want March -- of the same year?

if yes:

=sumproduct(d10:d100,
--(text(b1:b10,"yyyymm")
=text(date(year(today()),month(today())+2,1),"yyyymm")))




--

Dave Peterson
.
Thank you!