Forum Discussion
is it possible to calculate a weighted average (SUMPRODUCT) in a way that it ignores 0 and #DIV/0!?
Hello fellow Excel users, I need to calculate a weighted average (SUMPRODUCT) but since one of the criteria has 0 value it shows the error #DIV/0! - the formula is not working. Is it possible to ...
That could be
=SUMPRODUCT( IFERROR(C4:C6, 0 ), IFERROR(D4:D6, 0 ) ) / SUM(C4:C6)Use as array formula (Ctrl+Shift+Enter) if you are not on Excel 365 or 2021