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).

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

Related posts:

• Create a unique distinct list from a date range in excel
• Extract dates and adjacent value in a range using a date critera in excel
• Count unique distinct records in a date range and a numeric range in excel
• Sort dates within a date range using excel array formula
• Count unique records by date in excel
• Lookup two index columns using min max values and a date range as criteria

• Most common value between two dates in excel
• Count records between two dates in excel
• Count unique distinct records in a date range
• Count unique records by date

• Count unique distinct values using date criteria in a range in excel
• Determine the sum between a range of dates for a specific currency
• Most common value between two dates in excel

Related posts:

1. Count date records between two dates in a range in excel
2. Most common value between two dates in a range in excel
3. Count unique distinct values using date criteria in a range in excel
4. Most common value between two dates in excel
5. Count unique records by date in excel
6. Count unique distinct records in a date range and a numeric range in excel
7. Count unique distinct months in excel
8. Count overlapping dates in excel
9. Largest value in a range using date criteria in excel