Re: Sumproduct and dates

There is no need for the extra parenthesis


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




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


Peo Sjoblom

"Lee" <lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
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.