sumif inside a sumproduct!!

**ratkiller** · 05-02-2012, 05:18 AM

My original formula was:

=SUMIF('Delivered Material Data'!E2:E10000, Report!C49, 'Delivered Material Data'!F2:F10000)

But I wanted to add only the cells that are within a specific date range, so I did this:

=SUMPRODUCT(('Delivered Material Data'!D2:D10000>=Report!B6)*('Delivered Material Data'!D2:D10000<=Report!B7)*(SUMIF('Delivered Material Data'!E2:E10000, Report!C49, 'Delivered Material Data'!F2:F10000)))

The result I got was totaly wrong, so what is it that I'm not getting?

Report: sheet1
Delivered Material Data: sheet2
B6: start date in sheet1
B7: end date in sheet1
Delivered Material Data D2:D10000 : the dates in sheet2
Delivered Material Data F2:F10000 : the values to add in sheet2
Delivered Material Data E2:E10000 : the name to match in sheet2
C49: string in sheet1

Please help

**Fotis1991** · 05-02-2012, 05:24 AM

Hi

Something like this, maybe?

=SUMPRODUCT(('Delivered Material Data'!D2:D10000>=Report!B6)*('Delivered Material Data'!D2:D10000<=Report!B7)*('Delivered Material Data'!E2:E10000=Report!C49)*('Delivered Material Data'!F2:F10000))))

Or else, pls, upload a small sample workbook.

**Søren Larsen** · 05-02-2012, 05:25 AM

Try this instead:

=SUMPRODUCT(('Delivered Material Data'!D2:D10000>=Report!B6)*('Delivered Material Data'!D2:D10000<=Report!B7)*('Delivered Material Data'!E2:E10000=Report!C49),'Delivered Material Data'!F2:F10000)