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
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