Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The normal GEOMEAN function is assuming that all the various numbers are equally weighted, but in this case it's not, so how can I calculate a weighted geometric mean?

share|improve this question

There's no built-in formula for this, but you can use SUMPRODUCT to assist. See:

share|improve this answer

I think you can use SUMPRODUCT to calculate a weighted average but I'm not sure how you can do that with a weighted geometric mean.

Assuming values in A1:D1 and weights in A2:D2 try this "array formula"


confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula

if all the values in A2:D2 (the weights) are the same then that formula will give you the same result as


That formula should give you the same results as the calculator here

Note: you can remove the SUM function if weights sum to 1

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.