Sum Product

[lejanco]

Hello,

I am trying to find a formula for column e on the PO Costs EOY sheet. My criteria is as follows:

1.Column b on PO Costs EOY= Column A on TableTop
2.The order date in Column A is equal or in between the dates on rows 2 and 3 in Tabletop
3. I do not want to include in the sum anything before order date, ie, if the order date is 8/8, i only want to sum 8/9 and greater. Basically, I am ordering what I will need in the future.
4. On another sheet similar to this, I used this formula (compliments of ExcelForm) and it worked, but now I am getting N/A
=SUMPRODUCT((TableTop!$A$5:$A$311=B2)*(TableTop!$X$2:$AW$2>=$A2)*(TableTop!$X$6:$AW$311))-D2
(D2 is subtracting the inventory on hand from the quantity needing to be ordered)


The order date will always be on the last day of the week. So the sum would start the follow week.

Thanks!!!!

[Jonmo1]

The dimensions need to be alligned...

Try

=SUMPRODUCT((TableTop!$A$5:$A$311=B2)*(TableTop!$X$2:$AW$2>=$A2)*(TableTop!$X$5:$AW$311))-D2

[Ace_XL]

Untested..

=SUMPRODUCT((TableTop!$A$5:$A$311=B2)*(TableTop!$X$2:$AW$2>=$A2)*(TableTop!$X$5:$AW$311))-D2

[lejanco]

Thank you!