Hi,
I searched for this but didn't manage to find a solution.
I have in a certain cell a range like M23:M178, this range is the result of match & concatenate. I want to use the range stored in that cell in a countif formula.
I got that to work but only with vba.
Example:
range("B2").formula="=countif(" & cells(1,1).value & ", ""criteria"")"
this works fine, but i don't have a autofill option for it and i need to do this for about 60 rows.
Any help is appreciated
I searched for this but didn't manage to find a solution.
I have in a certain cell a range like M23:M178, this range is the result of match & concatenate. I want to use the range stored in that cell in a countif formula.
I got that to work but only with vba.
Example:
range("B2").formula="=countif(" & cells(1,1).value & ", ""criteria"")"
this works fine, but i don't have a autofill option for it and i need to do this for about 60 rows.
Any help is appreciated