Varying rows formula
Posted by sjt on August 01, 2001 5:01 PM
I have a column (F) that needs to be summed. The formula needs to in column F right below the last row that is being summed. Each month, though, there will be a different amount of rows so the formula cell will vary. How can I write a macro that finds the last row in Column F and puts the formula in the cell right below it.
Example:
Month one Month two
F1= 2 F1=2
F2= 2 F2=2
F3= 2 F3=4(Sum)
F4= 6(sum)
Please Help!