View Single Post
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"Kellyatisl" wrote in message
...
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)?


You'll get some answers suggesting SUMPRODUCT, which is fine. The
*easiest-to-understand* way is ...

use 2 SUMIFs, ie: SUMIF(less than 1st Oct 04) *minus* SUMIF(less than 1st
Sept 04).

Rgds,
Andy