SUMIF Variable range of columns

[coop123]

Good Morning

I am struggling to get a SUMIF formula to work. Any help would be very much appreciated.

I have the following code with works,

ActiveCell.FormulaR1C1 = "=SUMIF(R12C3:R702C3,RC10,R12C:R702C)"

The columns always start at row 12, but last row will vary. How do I change R702 to something that is not fixed.

Already in the macro I use ListEnd to define last row in a column, but when I try to add this to the range I cannot get it to work.

Thanks in advance.

Coop123

 

[RoryA]

You need to concatenate it in:

ActiveCell.FormulaR1C1 = "=SUMIF(R12C3:R" & ListEnd & "C3,RC10,R12C:R" & ListEnd & "C)"

 

[coop123]

Perfect.

I was putting ListEnd in the wrong place in the formula.

Thank you again.

Coop123