Well it isn't a straight average as you probably know, so it could be a weighted average....but you'd need to know the weights, if %s are in A2:A5 and the weights in B2:B5 you could get the result with
=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)
Well it isn't a straight average as you probably know, so it could be a weighted average....but you'd need to know the weights, if %s are in A2:A5 and the weights in B2:B5 you could get the result with
=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks