Assuming that Column A contains the date, and Column B contains the
expense amount, try the following...
=SUMPRODUCT(--(A1:A100=DATE(2004,9,1)),--(A1:A100<=DATE(2004,9,30)),B1:B
100)
or
=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),B1:B100)
....where C1 contains your start date, and D1 contains your end date.
Hope this helps!
In article ,
"Kellyatisl" wrote:
I want to use the sumif function to add up all expenses that occur between
two dates (Say, during the month of September, so between 09/01/2004 and
09/30/2004). I can't figure out how do use sumif with two arguement (sumif
criteria is THIS AND THIS)?
|