ExcelBanter - weighted average

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - weighted average (https://www.excelbanter.com/excel-discussion-misc-queries/86166-weighted-average.html)

inoexcel

weighted average

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

Thanks

--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=537753

Jerry W. Lewis

weighted average

=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(we ights),weights)) /
SUMPRODUCT(IF(ISNUMBER(weights),weights))

Jerry

"inoexcel" wrote:

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

Thanks

--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=537753

inoexcel

weighted average

awesome, thanks Jerry!

--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=537753

Jerry W. Lewis

weighted average

You're welcome. Glad it helped.

Jerry

"inoexcel" wrote:

awesome, thanks Jerry!

--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=537753

All times are GMT +1. The time now is 01:27 AM.