=IF(ISNA(A1),0,A1)+IF(ISNA(A3),0,A3)+IF(ISNA(B4),0 ,B4)+IF(ISNA(C5),0,C5)+IF(ISNA(F6),0,F6)

If this post helps click Yes
---------------
Jacob Skaria


"tywlam" wrote:

Couldn't solve my problem! I don't want to handle the cells with #N/A value
but the adding formula that can function correctly without being affected by
those #N/A cells!



"Jacob Skaria" wrote:

Try handling the error for these cells using

=IF(iserror(..

If this post helps click Yes
---------------
Jacob Skaria


"tywlam" wrote:

Thanks. But how can I get a result of a simple formula of adding different
cells (instead of a range) that have some #N/A?

For example: = a1+a3+b4+c5+f6, but b4 and f6 have #N/A !

Regards,


"Jacob Skaria" wrote:

For summing Range A1:A10 use the below formula...Please note that this is an
array formula. Within the cell in edit mode (F2) paste this formula and press
Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you
can notice the curly braces at both ends like "{=<formula}"

=SUM(IF(ISNA(A1:A10),"",A1:A10))


If this post helps click Yes
---------------
Jacob Skaria


"tywlam" wrote:

How do I sum the values in cells without adding those #N/A in some cells?

Please help.

tywl