Need to calculate cumulative efficiency of dayly production figures

**Anuru** · 12-10-2013, 09:52 AM

Please look in to the "cumulative effi" in the row 17, here I need to calculate cumulative efficiency irrespective of the style no in the row 5. Pls kindly help me get that done. However, this contains combination of other cells that are needed to do the efficiency calculation.

Here is the required formula:

Cumulative efficiency = [ { (C10 X C12)+ (D10 X D12)+ (E10 X E12)+………..(N10 X N12)} / {(C7 X C8) + (D7 X D8) +(E7 X E8)+ ……………(N7 X N8)}] x 100

Please note that this formula should function disregarding the change of the style no in the row C5, D5, E5 and so on. It should produce the cumulative product of irrespective of style change.

**amit.wilson** · 12-11-2013, 10:20 AM

Hello A,

haven't quite understood what you are trying to achieve.

This:

Cumulative efficiency = [ { (C10 X C12)+ (D10 X D12)+ (E10 X E12)+………..(N10 X N12)} / {(C7 X C8) + (D7 X D8) +(E7 X E8)+ ……………(N7 X N8)}] x 100

can be simplified to

Formula:

Please Login or Register  to view this content.

I assume this goes into N17. And can be copied to the other cells in row 17 so as to calculate the cumulative efficiency from C to that particular column.

Is this what you needed?

Cheers