With Excel 2007 you have a new function, SUMIFS(). It allows upto about 15
separate criteria, so for example with date1 in B2 and date2 in B3,
=SUMIFS(sum_range,criteria1_range,""&B2,criteria2 range,"<="&B3) would return
the desired sum.


"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)?