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

Recommended article

Sum values in a range where adjacent cell value equals a criterion

Question: How do I sum all values in a range where adjacent cell value equals a criterion? The criterion is […]

Alternative excel 2003 formula in C19:

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

Recommended post

Sum cells with check boxes

I will now demonstrate with the following table how to add check-boxes and sum enabled check-boxes using a formula. Add […]

Alternative array formula:

=SUM((B3:B10<=C14)*(B3:B10>=C13)*(C3:C10=C15)*D3:D10)

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

Recommended article

Sum only if unique value in another column in excel

Question: How do I sum values only if a unique value exists in another column? Answer: Formula in D13: =SUM(IF(COUNTIF(List1, […]

Download excel file for this tutorial

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

Functions in formulas above

Excel SUM function

The SUM function in excel allows you to add values, the function returns the sum in the cell it is […]

How to use Excel SUMPRODUCT function

Multiplies cell ranges and then sum all values.

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:

=SUMPRODUCT((($B$6<=$B$1:$D$1)*($B$7>=$B$1:$D$1))*($A$2:$A$4=$B$8)*$B$2:$D$4)

Download excel *.xlsx file

Farhan.xlsx

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