Re: Sumproduct and dates



There is no need for the extra parenthesis

=SUMPRODUCT(--(SPRING4!N2:N1549<=--"1/31/07"),SPRING4!M2:M1549)

however you were looking for the text string 1/31/07, the unary minuses will
take care of that although it might be better to use either

=SUMPRODUCT(--(SPRING4!N2:N1549<=DATE(2007,1,31)),SPRING4!M2:M1549)

or


=SUMPRODUCT(--(SPRING4!N2:N1549<=H2),SPRING4!M2:M1549)

where you would put the date in a cell (H2 in my example)


--
Regards,

Peo Sjoblom



"Lee" <lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eJ6TLohyHHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
=SUMPRODUCT(--(SPRING4!N2:N1549<="1/31/07"),(SPRING4!M2:M1549))
Above is my formula that I can't get to work with dates. I want to sum the
M2:M1549 based on the date column of N. What am I doing that is wrong?
The date column is formated as mm/dd/yy.
Thanks to all for any help.
--
Lee



.