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

Related posts:

  • Share/Bookmark

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