another way:

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

Ctrl+Shift+Enter



On 22 Maj, 09:46, 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- Ukryj cytowany tekst -

- Pokaż cytowany tekst -