SUMIF Criteria

[sreeder]

My range has various dates. The criteria needs to be a range from 08/01/02 to 08/31/02 not just a sepcific date. Any sugestions?

 

[Aladin Akyurek]

On 2002-09-25 12:27, sreeder wrote:
My range has various dates. The criteria needs to be a range from 08/01/02 to 08/31/02 not just a sepcific date. Any sugestions?

=SUMIF(DateRange,">="&E2,RangeToSum)-SUMIF(DateRange,">"&F2,RangeToSum)

where DateRange is the range that houses true date, RangeToSum is the range that you want conditionally sum, E2 houses a date like 08/01/02 and F2 another date like 08/31/02.
Note that E2 < F2. This formula computes according an inclusive between condition.

 

[sreeder]

Thanks! Works great.