Help with IFERROR

[kenjcd]

How can I use IFERROR with the following formula?

=((C2)+(D2*1)+(E2*2)+(F2*3)+(G2*4)+(H2*5)+(I2*6)+(J2*7)+(K2*8)+(L2*9))/N2

[AliGW]

I think you mean this:

=((C2)+(D2)+IFERROR((E2*2),0)+IFERROR((F2*3),0)+IFERROR((G2*4),0)+IFERROR((H2*5),0)+IFERROR((I2*6),0)+IFERROR((J2*7),0)+IFERROR((K2*8),0)+IFERROR((L2*9),0))/N2

[alansidman]

https://www.techonthenet.com/excel/formulas/iferror.php

[TMS]

The only reason for an error in that formula is if N2 is zero.

So you could just use:

Please Login or Register  to view this content.

If you do want IFERROR, then:

Please Login or Register  to view this content.

[Pepe Le Mokko]

me likes
=iferror(sumproduct(c2:l2*(row(a1:a10)-1))/n2,0)

[kenjcd]

The only reason for an error in that formula is if N2 is zero.

So you could just use:

Please Login or Register  to view this content.

If you do want IFERROR, then:

Please Login or Register  to view this content.

Solved the problem.
Thank you all!
Rep added!

[TMS]

You're welcome. Thanks for the rep.

@Ali: your solution would fail if N2 = 0; the IFERROR woud need to be round the whole formula.

@Pepe: your formula looks neat but it doesn't appear to work. Am I missing something?

@kenjcd: you can lose all the "internal" brackets in both solutions. For example

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

although you might find it more readable if you retain the brackets ... though it is shorter