weighted average

  • Thread starter Thread starter inoexcel
  • Start date Start date
I

inoexcel

Hi, how do I calculated a weighted average, but excluding cells that
have #div/0! or 0.

Thanks
 
=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(weights),weights)) /
SUMPRODUCT(IF(ISNUMBER(weights),weights))

Jerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to calulate the weighted average 4
Conditional sumif? 5
Formula for Weighted Average 2
How do I calculate weighted averages of grades? 1
weighted average in pivot excel 2007 1
weighted average on a pivot table 2
Weighted Average across worksheets 5
Moving Weighted Average formula 5

Back
Top