How to calculate Inventory equation

[tiong999]

Hello all,

I need someone to fresh my brain for not flowing how to formulate inventory equation base on different small unit.

Lets open attach file, thanks for your guidance for me.


Regards,
Tiong

 

[rahulshewale1]

Hii,

Could you please explain criteria or logic?


Regard

Rahul shewale

 

[tiong999]

Hii,

Could you please explain criteria or logic?


Regard

Rahul shewale

Helo rahul,

Sorry i didnt explain it better. Here attach i update new file.
Hope u can see math behind it i try to explain.

Regards,
Tiong

 

[tiong999]

Helo rahul,

Sorry i didnt explain it better. Here attach i update new file.
Hope u can see math behind it i try to explain.

Regards,
Tiong

Just notice, i havent changed formula i paste from cell b19, since i deleted 2 rows before i post new attachment.

B17 =SUMPRODUCT(--($A$4:$A$6=A17);($B$4:$B$6))+SUMPRODUCT(--($A$10:$A$13=A17);($B$10:$B$13))

 

[John Jairo V]

Hi, tiong999!

I think the column "volume" is left over. Check the attachment. Blessings!