Harmonic Mean

Also known as Weighted Harmonic Mean or Subcontrary mean
This is the reciprocal of the arithmetic mean of the reciprocals.
What is the harmonic mean of the numbers 1, 2 and 4.

Excel Function

If you do need to calculate the harmonic mean then you can use the worksheet function HARMEAN.