MrExcel Publishing
Your One Stop for Excel Tips & Solutions

weighted average


Posted by John Wright on January 23, 2002 10:10 AM

Please help! I need to do a weighted average in Excell, any ideas?


Posted by Tanya on January 23, 2002 10:22 AM

Use the SUMPRODUCT and SUM functions. For example: Let's say you want to find an average price per pound (weighted). Assuming you have prices in A1:A10 and weight(lbs) in B1:B10 use the following formula:
SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)