Sum only numeric value

Closed
Goutam - 30 May 2011 à 03:49
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 30 May 2011 à 04:47
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
  • Saints row 2 cheats - Guide
  • Igi 1 - Download - Shooters
  • My cute roommate 2 - Download - Adult games

1 response

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

Now sum the cells.