CODEWITHSUNDEEP
google-sheets
mahmood
mahmood

Reputation: 24765

Weighted harmonic mean with Google Sheets

Using Google sheets, I would like to calculate the weighted harmonic mean of two columns named Weight and Value. Using the normal method, I have to add a third column to find Weight/Value and the calculate the W.H.M as SUM(Weight)/SUM(Weight/Value).

enter image description here

Is there a way to find that value without the extra column?

Upvotes: 0

Views: 260

Answers (2)

Manoj
Manoj

Reputation: 461

My approach here..

result

=SUM(A2:A5)/SUMPRODUCT(A2:A5,1/B2:B5)

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36965

Try the following formula-

=SUM(A2:A5)/SUM(INDEX(A2:A5/B2:B5))

enter image description here

Upvotes: 1

Related Questions