Need help using formula to get output

[Dinesh_Excel]

Hello All,

I need your help in applying formula for the ones highlighted in yellow.
The output for the entire rows marked in yellow are highlighted in green.

Appreciate your help here.

Attached sheet for your reference.

 

[AliGW]

The numbers you have quoted do not seem to match the results of the formulae in the green cells.

 

[vletm]

Dinesh_Excel
You'll find needed from this ..

 

[Dinesh_Excel]

Thank you Vletm and AliGw.....appreciate your help .