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 ***