# Sum cell values in a column

#### Gonzalo De La Torre

##### New Member
The idea is the following:

Dim VariableRow As String

ActiveCell.FormulaR1C1 = "=SUM(RC[-2]:R[VariableRow]C[-2])"

I have values in column A but in column B i have nother value that it is going to tell the number of rows the sum is going to cover in column A Can this be done in VBA or just by using a simple formula Example:

--------------------------------Column C
Row Number|Column A|Column B|Sum Result
----1------|----1----|---3----|----8-----------Sum = Range(A1:A3)
----2------|----2----|---0----|
----3------|----5----|---0
----4------|----2----|---4----|----9-----------Sum = Range(A4:A7)
----5------|----2----|---0----|
----6------|----2----|---0----|
----7------|----3----|---0----|

Can anyone help me out with this issue?

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### wigi

##### Well-known Member
In C1 and below:

=IF(B1,SUM(OFFSET(A1,,,B1,)),"")

Excel Workbook
ABC
1138
220
350
4249
520
620
730
Sheet

#### Gonzalo De La Torre

##### New Member
Thank you very much to both of you.

Both formulas work great.

Replies
9
Views
56
Replies
7
Views
68
Replies
1
Views
30
Replies
10
Views
281
Replies
4
Views
70

1,141,203
Messages
5,704,929
Members
421,372
Latest member
Jamie11

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back