juanito
Member
Hi all - I want to find a formula which can extract a weighted average where there is only one Values column. I can do this by pivoting into two columns easily enough (see solution to the right), but prefer to find a formula which can act directly on the data table as presented... and I haven't been able to do this by myself.
In the example attached, I want to evaluate the average of Quality, weighted by Hours.
Thanks in advance!

In the example attached, I want to evaluate the average of Quality, weighted by Hours.
Thanks in advance!
