Formula for date range with multiple criteria 1

[bwm1952]

I am needing to look up a date range of July, 21, 2011 through July 25, 2011 and if it is within that date range the material needs to match 068-GRD. If both of those criterias are met then I want Mat'l Qty to be summed.


Start Material Mat'l Qty
July 21, 2011 068-GRD 11.67
July 22, 2011
July 22, 2011
July 25, 2011
July 25, 2011
July 28, 2011
July 22, 2011 M-088-GRD 26.4
July 26, 2011
July 28, 2011
July 22, 2011 068-GRD 4.4
July 25, 2011
July 21, 2011 1659-GRD 301.14
July 27, 2011
August 2, 2011
August 3, 2011
August 5, 2011 1359-GRD 56.76
August 5, 2011
July 27, 2011 068-GRD 0.7

 

[SkipVought]

hi,

FIRST, in a proper table Material values appear on EVERY ROW applicable.

If your use Excel 2007+, then then SUMIFS() function will work. Otherwise, use the SUMPRODUCT() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bwm1952]

Here is the formula that I have so far but I am getting an error message saying the formula you typed contains an error.

=SUMPRODUCT(--($B$2:$B$270="068-GRD"), --($A$2:$A$270>=DATE(July 21, 2011)),--($A$2:$A$270<=DATE(July 25, 2011)), ($C$2:$C$270))

 

[SkipVought]

[tt]
=SUMPRODUCT(--($B$2:$B$270="068-GRD"), --($A$2:$A$270>=DATE(2011,7,21)),--($A$2:$A$270<=DATE(2011,7,25)), ($C$2:$C$270))
[/tt]
check HELP on the DATE() function

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}