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: