hi guys,
I am trying to find the harmonic mean for the range X10:X1329, but only want to include rows where AE10:AE1329 = "W"
When I have resolved that I want to move it further forward by adding a 2nd condition, ie, A:A meets the same data in cell R1338.
Any ideas, I have tried if formula...