Hi,
I'm looking for a formula to determine a weighted average of productivity rates (tonnes/hour), weighted by their hours but only if the denominator is nonzero.
I have the tonnes in the vector A1:A10 and the hours in the vector B1:B10.
Thanks!
I'm looking for a formula to determine a weighted average of productivity rates (tonnes/hour), weighted by their hours but only if the denominator is nonzero.
I have the tonnes in the vector A1:A10 and the hours in the vector B1:B10.
Thanks!