Formula to sumif multiple condition

[Ateeb Ali]

Dear Sir
I have attached a file with highlighted example, I need formula which "sum if" multiple condition.

For example:
Condition 1: Column Desc. + WO# + Count / Ply = Sum Range Total Kg (2-Ordered)
Condition 2: Column Desc. + WO# + Count / Ply = Sum Range Total Kg (3- Received)

In attached file, I have done manually and highlighted it for better understanding.

 

[trprasad78]

Hi check attached file, using sumifs as well as pivot table i bring the result.

 

[Ateeb Ali]

Sir I tried this formula, it is not happening, I dont need it in separate sheet nor I need pivot option.
I input data in this sheet daily, I just want to see the balancing in forward column so mistake can be avoided

Formula I tried, not working
=SUMIFS($K$2:$K$8156, $A$2:$A$8156,Sumif!A2, $D$2:$D$8156,Sumif!D2,Detail!$G$2:$G$8156,Sumif!G2)

 

[trprasad78]

Sir I tried this formula, it is not happening, I dont need it in separate sheet nor I need pivot option.
I input data in this sheet daily, I just want to see the balancing in forward column so mistake can be avoided

Formula I tried, not working
=SUMIFS($K$2:$K$8156, $A$2:$A$8156,Sumif!A2, $D$2:$D$8156,Sumif!D2,Detail!$G$2:$G$8156,Sumif!G2)

I still not understand what exactly you want.
do you need total ordered and total received kg ?

 

[trprasad78]

check the attached file, where you will get order vs received and difference in same screen

 

[Ateeb Ali]

Sorry dear, I don't need pivot option, I just need formula help.
See attached file again, I have highlighted in yellow, this I do daily, so I need to see the formula result on every entry

 

[Peter Bartholomew]

There are a lot of repeat calculations and I suspect that the file will need optimising for speed before long.

 

[Peter Bartholomew]

I hadn't filled down one of the formulas so the final column showed a lot of red.

This file also has an exercise in the use of modern dynamic arrays which will not work in anything other than Office 365 insider. What I attempted there was to create a list of unique orderNumber / part combinations so that the order balances were not replicated. This required filtering on two separated columns and then picking the columns separately as parameters in the SUMIFS.

I suspect that a whole new bag of tricks will be needed to get the best out of dynamic array formulas.

 

[Ateeb Ali]

Dear Sir,
Thanks a lot, this formula really working fine;

= SUMIFS([TOTAL KG], [W.O'#], [@[W.O'#]], [Count / Ply], [@[Count / Ply]], [DESC.], "2-Ordered" )