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
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 30 May 2011 à 04:47
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
30 May 2011 à 04:47
copy the cell in to new sheet than replace Rs. with "" (blanks).
Now sum the cells.
Now sum the cells.