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
- Write a shell program to find the sum of the series sum=1 + 3 + 5 + 7 + …+ n
- Code for Write a shell program to find the sum of the series sum=1 + 5 + 9 + ...+ n in Unix
- sum of amount deliverd group
- Calculate Total Sum
- Sum colunm total in repeater
- count the sum of a column
- custom Sum function?
- Summing a range of variable size
- Loop, sum values and paste
- VBA code to sum
- sum in columns
- Summing a range
- getting the sum of the last 20 cells
- Conditional Summing
- sum formula
- how to sum the even numbers only
- Sum values entered into text boxes
- sum cells with conditional formatting color
- sum of series of natural numbers