Help - Calculate sum based on numeric value and store separately

[ExcelUser2707]

Hi Experts

Require your valuable help to sort-out my equation

I want to calculate sum base on numeric value.

e.g. row number 2 having multiple numeric value 101, 102, 105,106, 281, 282, 201 etc. I want formula based on numeric 101, 102,105, 106 will combine sum and will be add in column “X”.

hoping I elaborate clearly, still I attached sample file with required result

Thanks

Amar K

[:) Sixthsense :)]

Not sure what is your actual problem since your current addition formula is getting the desired result for you...

[ExcelUser2707]

Hi Sixthsence

Thanks for your reply…..

Yes my current addition formula is giving result what I want..

But problem is, row number 2 which is having numeric value will change every time. It will never in same order. I want to formula to search this value and calculate the sum
As 101 102 will be added in total receipt quantity, 281 282 will be add on total issue quantity.

Hoping now I describe scenario.

Thanks

Amar K

[:) Sixthsense :)]

Thanks for the clarification


In X3 Cell


=SUM(SUMIF($D$2:$K$2,{101,102,105,106,122,123},D3:K3))


Drag it down...

Apply the same (above) logic for Total Issue also

[ExcelUser2707]

Hi Sixthsence

Thanks a lot to resolve my problem…. Yes sumif is doing what I am expected.

Thanks again for your prompt reply and valuable help.

Regards

Amar K