Calculating geometric mean

[besbesmany]

I have 2 sets of data columns A1:A6 and B1:B6

I want to calcuate the attached formula where n=6=count(A1:A6)

Untitled.png

[oeldere]

You get better help if you post an Excel-file (example of your workbook), without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.

[besbesmany]

This is what i need
Attachment 178000

[oeldere]

Your file have no extension .xls so i can't open it.

[MrShorty]

Isn't that the geometric mean of those quotients? IMO, the easiest way would be to add a column/row where you calculate the quotient for each entry in your data sets, then use the GEOMEAN() function. Search Excel help for the geomean() function.

[besbesmany]

Ok I make it xls now eq.xls

[besbesmany]

can you give it to me exactly
I didn't understand which colum/row i should divid and how to put it in geomean

[oeldere]

Now I can open the filie.

But i can't help you with the math problem.

[besbesmany]

Here is the solution wish it can help someone
eq.xls

[zbor]

Thanki you for sharing your solution.
However, next time please name your title according to forum rules.
This time I've change it for you.

Also don't ignore requests to do so.

[shg]

I think your answer is wrong.

=GEOMEAN(INDEX(A1:A6/B1:B6, 0))

[besbesmany]

thanks for your forum
I didn't ignore request i sent new title to
arlu1201
via private message

Thanki you for sharing your solution.
However, next time please name your title according to forum rules.
This time I've change it for you.

Also don't ignore requests to do so.

[besbesmany]

I calculate it from the following video

http://www.youtube.com/watch?v=s-DXD1W48A8

please revise it and tell me is this way right or yours?

I think your answer is wrong.

=GEOMEAN(INDEX(A1:A6/B1:B6, 0))