Sum only numeric value

Closed
Goutam - May 30, 2011 at 03:49 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 30, 2011 at 04:47 AM
Cell
A1 Rs.100
A2 Rs.150
A3 Rs.160

Please tell me how I can sum only numeric value. Please tell me the formula.

Regards,

Goutam Goswami
Related:

1 response

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 30, 2011 at 04:47 AM
copy the cell in to new sheet than replace Rs. with "" (blanks).

Now sum the cells.
0