In this post, I will provide a formula to sum values in column (Qty) where an column (Date) meets two date criteria and an additional criterion in an adjacent column (Product).

Sum values between two dates with criteria

I have colored the cells in column Qty that meet all criteria.

Excel 2007 formula in C18:

=SUMIFS(D3:D10, C3:C10, "="&C15, B3:B10, "<="&C14, B3:B10, ">="&C13) + ENTER

Alternative excel 2003 formula in C19:

=SUMPRODUCT(--(B3:B10<=C14), --(B3:B10>=C13), --(C3:C10=C15), D3:D10) + ENTER

Download excel file for this tutorial.

Sum values between two dates with criteria.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

SUMPRODUCT(array1, array2, )
Returns the sum of the products of the corresponding ranges or arrays

SUMIFS(sum_range, criteria_range1, criteria1,..)
Adds the cells specified by a given set of conditions or criteria

Farhan asks:

Site 6-Nov-12 7-Nov-12 8-Nov-12
2254 10 20 30
2253 10 20 10
2254 10 0 51
Criteria: required 2254 sum of values b/w my specified date let say from 6-8 Nov.

Formula in cell B9:


Download excel *.xlsx file