formula question
 

A
1
a
2
1
w

in the case ,the following upper ...
i want to sum only number.

the answer is 4
in the cell B1, =SUMPRODUCT(ISNUMBER(A1:A5)*(A1:A5))
but, not working...

*** Sent via Developersdex http://www.developersdex.com ***

formula question
 

"tom taol" skrev i en meddelelse
...

A
1
a
2
1
w

in the case ,the following upper ...
i want to sum only number.

the answer is 4
in the cell B1, =SUMPRODUCT(ISNUMBER(A1:A5)*(A1:A5))
but, not working...


Hi tom

=SUM(A1:A5) will do, because the SUM() function skips
text values.

If all entries are text, you can use this array formula:

=SUM(IF(NOT(ISERROR(VALUE(A1:A5))),VALUE(A1:A5)))

To be entered with <Shift<Ctrl<Enter, also if
edited later.


--
Best regards
Leo Heuser

Followup to newsgroup only please.