I am struggling with syntax and have tried many different variations. Here is the formula I am trying to get to:
=COUNTIFS(E12:E425,"High")
I typed this in and recorded macro. I then wanted to modify to replace the line number w/ the last line of data.
So I updated my macro to this:
ActiveCell.FormulaR1C1 = "=COUNTIFS(E12:E" & LastRow & ",""High"")"
It comes out in my spreadsheet like this:
=COUNTIFS('E12':'E425',"High")
I don't know why I am getting the extra quotes around the range values. I have used this type of syntax to pull in the last line in many different formulas with no problem, but the COUNTIFS isn't working. I have tried so many variations. What am I doing wrong?
=COUNTIFS(E12:E425,"High")
I typed this in and recorded macro. I then wanted to modify to replace the line number w/ the last line of data.
So I updated my macro to this:
ActiveCell.FormulaR1C1 = "=COUNTIFS(E12:E" & LastRow & ",""High"")"
It comes out in my spreadsheet like this:
=COUNTIFS('E12':'E425',"High")
I don't know why I am getting the extra quotes around the range values. I have used this type of syntax to pull in the last line in many different formulas with no problem, but the COUNTIFS isn't working. I have tried so many variations. What am I doing wrong?