Sum Formula in Excel

  • Thread starter Thread starter chrismania
  • Start date Start date
C

chrismania

Hi Guys,
hopefully somebody can help.

I have columns of data, and I want to sum up at the bottom of each
column the total for each column. I know how to do this, but the range
of the columns can change each time because the number rows can be
different for each month.

So if i find the last row of each column, how do i then select from
there up to calculate the sum??

What I'm trying to do is, if a column contains all zero's or a row
contains a whole row of zero's then delete the entire row/column. Is
there an easier way of doing this??

Thanks Christoph
 
Hi chrismania

This example will work for Column C

Sub test()
With Range("C" & Rows.Count).End(xlUp).Offset(2, 0)
.Formula = "=SUM(C1:C" & .Row - 3 & ")"
End With
End Sub
 
something like this will work for the rows
Sub delnonums()
lastrow = Cells(65536, "a").End(xlUp).Row
For x = lastrow To 1 Step -1
If Application.Sum(Range(Cells(x, 1), Cells(x, 256))) = 0 _
Then Cells(x, "a").Rows.Delete
Next
End Sub
 
Back
Top