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. Count records between two dates in excel
3. Most common value between two dates in a range in excel
4. Count unique distinct values in two columns with date criteria in excel
5. Most common value between two dates in excel
6. Count unique distinct values using date criteria in a range in excel
7. Count unique records by date in excel
8. Count duplicate distinct values in a column in excel
9. Count unique and unique distinct values in a multicolumn range in excel
10. Count unique values and unique distinct values in two ranges combined