' finds the last row of column F
LastRow2 = Range("F" & Rows.Count).End(xlUp).Address
'this is the formula I'm trying to enter
ActiveCell.Formula = "=SUMPRODUCT(COUNTIFS(F2:F" & LastRow2 & ",RC[-1]))"
It does go into the cell need by appears with extra marks around the cell reference
=SUMPRODUCT(COUNTIFS('F2':'F6',E8))
Any help will be much apricated.
Thank you
LastRow2 = Range("F" & Rows.Count).End(xlUp).Address
'this is the formula I'm trying to enter
ActiveCell.Formula = "=SUMPRODUCT(COUNTIFS(F2:F" & LastRow2 & ",RC[-1]))"
It does go into the cell need by appears with extra marks around the cell reference
=SUMPRODUCT(COUNTIFS('F2':'F6',E8))
Any help will be much apricated.
Thank you