sumif criteria

B

boris

I need the criteria for a sumif to evaluate a range that
has dates in it, and make sure that a particular date is
between one cell's date and another cell's date (but they
are not fixed, so I cannot just enter the actual dates).
And once I copy that cell across, the two cells that the
criteria refers to for comparison will move along with it
to the right. How do I accomplish this, given that the
quotes in the sumif are looking for specific values?

Thanks much.

Boris
 
A

Aladin Akyurek

=SUMIF(DateRange,">="&X2,RangeToSum)-SUMIF(DateRange,">="&Y2,RangeToSum)

would sum values corresponding to dates >= X2 and dates < Y2.
 
Top