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