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
- Create a constructor class Sum
- sum and Multiply number and print in decimal
- 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 cells with conditional formatting color
- Conditional Summing
- Sum values entered into text boxes
- sum formula
- how to sum the even numbers only
- 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