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

Alternative array formula:


Press and hold CTRL + SHIFT simultaneously and then press Enter to create an array formula.

Download excel file for this tutorial

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

Sum formula examples

Sum values where adjacent cell value equals a criterion
This post demonstrates how to sum adjacent values using a condition.
This article demonstrates how to insert check boxes to your worksheet, how to link check boxes to cells and how to construct a formula that add values depending on the state of the check-boxes.
Sum only if unique value in adjacent column
This post explains how to construct a formula that adds values if adjacent value is unique.
Excel SUM function
Explains how the SUM function works with many examples

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


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