see attached example.
I would like to accomplish what I show via adding other rows to do the intermediatry calcs in multiple steps in a single formula
I have a row of numbers, and would like to divide each cell in that row (giving a ratio for each cell in the row)- and then averaging all of these ratios to get an overall ratio
The data given are in Cols A:C
I'm trying to produce cells G12 and H12 via cell formula
without the need of creating cells G4:H8
Using MS Excel 07