Hi there,
I need to be able to using a dynamically expanding range and am having some trouble with a formula using R1C1 notation with a COUNTIF statement.
Basically, I need to base my countif on the number of rows with content in column A.
You can see that in the code below that the range is...