Hi, how do I calculated a weighted average, but excluding cells that have #div/0! or 0. Thanks
I inoexcel May 1, 2006 #1 Hi, how do I calculated a weighted average, but excluding cells that have #div/0! or 0. Thanks
J Jerry W. Lewis May 1, 2006 #2 =SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(weights),weights)) / SUMPRODUCT(IF(ISNUMBER(weights),weights)) Jerry
=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(weights),weights)) / SUMPRODUCT(IF(ISNUMBER(weights),weights)) Jerry
