BETWEEN DATES SUM

  • Thread starter Thread starter Jerry Kinder
  • Start date Start date
J

Jerry Kinder

Hi,

Col A has dates in order
Col B has amounts

Cell D1 is the beginning date
Cell E1 is the end date

I want to sum Col B where the dates in ColA are between the dates in D1 and
E1.

Thanks for your help.

Jerry
 
You might try this instead. I tested my first formula this morning and got an
incorect result.
=SUMPRODUCT(--(A1:A100>=C1),--(A1:A100<=D1),B1:B100)

tj
 
=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)

Try something like the above.

A1:A9 would reference your dates to be summed.

B1:B9 references the column to be summed due to the specified date range.

Of course you would need to set your range in the identical format.

Hope this helps you out
 
Back
Top