Thank you frank, worked great.

"Frank Kabel" wrote:

Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)



"LOU" wrote:

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.