Forum Discussion
Solved
Sum and Subtract multiple cells with blank values without having the #Value Error
Hello folks! Once again I need your precious help. I have a sheet where I need to sum and subtract various amounts on the same row. It would be very simple if it weren't for the "#Value" Error. I...
Change
=E2 + I2 - L3
to
=N(E2) + N(I2) - N(L3)
or
=NUMBERVALUE(E2) + NUMBERVALUE(I2) - NUMBERVALUE(L3)
Change
=E2 + I2 - L3
to
=N(E2) + N(I2) - N(L3)
or
=NUMBERVALUE(E2) + NUMBERVALUE(I2) - NUMBERVALUE(L3)
Thank you very much