SumIF with mutiple criteria

Currently got sumif (=SUMIF(A3:A100,T2,D3:D100)) to workout how much of a product (listed in column A) has not been delivered on the first day of a 5 day working week (columns D, G, J, M, P) but am struggling to find how to sum for every subequent work day so i have an up todate figure of how much has not been sent. I am unable to use a final column to sum everything since these columns start off with a negative value for what is due and get adjusted based on expected and delivered figures in the adjacent columns

Not saying I'll answer this but can you post a sample file since you haven't specified enough info, e.g. what is T2 ?

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Been busy so not had time to reply earlier but managed to solve it. Can someone check the attachement, in case there is any improvement i can make.

Joey1- attachment unsuccessful.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

Should work this time.

Want to know if i can simplify the formula, as with some products i have 2 codes i have to use, which means i have to extend the formula to include this additional product code.

If I am understanding correctly then the following should yield the expected values:
For "Ordered", D9:D11, use: =IF(C9="","",SUMPRODUCT((E$1:S$1<=A$1)*(RIGHT(E$2:S$2,5)="order")*(C$3:C$5=C9)*(E$3:S$5)))
For "Delivered", E9:E11, use: =IF(C9="","",SUMPRODUCT((E$1:S$1<=A$1)*(RIGHT(E$2:S$2,3)="del")*(C$3:C$5=C9)*(E$3:S$5)))
For "Discrepancy", F9:F11, use: =IF(C9="","",SUMPRODUCT((E$1:S$1<=A$1)*(E$2:S$2="Variance")*(C$3:C$5=C9)*(E$3:S$5)))
For "Scheduled", G9:G11, use: =IF(C9="","",-SUMPRODUCT((E$1:S$1>=A$1)*(E$2:S$2="Variance")*(C$3:C$5=C9)*(E$3:S$5)))
Let us know if you have any questions.

Presuming these definitions apply:
"Ordered" = scheduled to be delivered on or before today (D9 and down):

Please Login or Register  to view this content.

"Delivered" = actually delivered on or before today (E9 and down):

Please Login or Register  to view this content.

"Discrepancy" (F9 and down):

Please Login or Register  to view this content.

"Scheduled"= scheduled to be delivered in FUTURE (G9 and down):

Please Login or Register  to view this content.

You're most welcome! If complete, please mark your thread as SOLVED (Thread Tools up top). Thanks -Lee