Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

how to SUM content of rows by looping when some rows

are empty.

just test for null (or maybe "") before adding, if it fails the

test just more on.

dim total

dim row

dim col

col = 2

For Row = 1 to 10

if not isNull(cells(row,col).value) then

total = total + cells(row,col).value

end if

next row

Didn't find what you were looking for?
Find more on SUM content of rows
Or get search suggestion and latest updates.

Related Topics:

- Summing on varying number of rows in Excel using VBA
- Data Sum rows not hidded
- Counting the rows If the next row value is same as the previous row
- Delete Part of Row and move next Row Down Up
- Move data from a column of row couplets to multiple rows of colum
- Check content of cell and delete content if criteria isn't met
- Loop, sum values and paste
- VBA code to sum
- sum in columns
- count the sum of a column
- Summing a range
- getting the sum of the last 20 cells
- sum of amount deliverd group
- custom Sum function?
- Summing a range of variable size
- Calculate Total Sum
- Sum colunm total in repeater
- sum cells with conditional formatting color
- sum of series of natural numbers
- sum and difference of 2 bcd numbers
- Compute the sum of both positive and negative elements of an array
- Getting the sum and percentage in Excel coulmn
- sum and Multiply number and print in decimal
- Conditional Summing
- Sum values entered into text boxes