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:
  • The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum
  • Tentacle locker 2 - Download - Adult games
  • Tentacle locker 1 - Download - Adult games
  • Igi 1 - Download - Shooters
  • Saints row 2 cheats - Guide
  • My cute roommate 2 - Download - Adult games

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.