Adding multiple Iferrors

[ecelaras]

Hello ,

I have a wrong value problem with this formula

=IFERROR($RQ1509;"")+iferror($PH1509;"")+iferror($PI1509;"")+iferror($QO1509;"")+iferror($RA1509;"")+iferror($QW1509;"")

Can anyone Help???

[jkj115]

use a comma instead of semicolon to separate arguments

[mrice]

Replace semicolon with a comma?

Do the cells being referenced give numbers or text when they are not in error? If it is the latter then you may need & instead of +

[ecelaras]

My excel uses semicolons to separate arguments

[Norie]

What is the problem?

[ecelaras]

The problem is that the formula above gives #value even though atlist one of the sells I am adding has a number

[Norie]

You are returning empty strings when there is an error.

If you add a number and an empty string it produces an error.

[ecelaras]

What can I do in that case ?

[Norie]

Try returning 0 instead of "".

[ecelaras]

ok thx that Worked!!!