Article updated on January 14, 2018

In this post, I will provide a formula to sum values in column (Qty) where a 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 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 [โฆ]

Sum number based on if a corresponding value is unique

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

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

Functions in formulas above

How to use the 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 the SUMPRODUCT function

The SUMPRODUCT function calculates the product of corresponding values and then returns the sum of each multiplication.

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 C10:

=SUMPRODUCT(((\$C\$7<=\$C\$2:\$E\$2)*(\$C\$8>=\$C\$2:\$E\$2))*(\$B\$3:\$B\$5=\$C\$9)*\$C\$3:\$E\$5)