I have a table of multiple ratios in Excel, e.g. 3:1, 4:1, 16:4, etc. How do I work out the average ratio from these ratios?
When I setup a ratio formula e.g.
=(D14/E14)&":"&(E14/E14) it returns the ratio for the numbers queried in this example of cells D14 & E14. I'm getting stuck though working out the average of all the ratios returned.
I can't query the ratio cells and get the average ratio. If that makes sense to anyone!