=COUNT(OFFSET(M9,0,0,$A$3-8,2))/$K$8
--
David Biddulph
"rhhince" wrote in message
...

That works for changing the number, but when I add a column, I am
faced with the same dilemma "M9:N" doesn't change to "N9:O"

On Jan 9, 12:23 pm, "Tyro" wrote:
=COUNT(INDIRECT("M9:N"&A3))/$K$8

"rhhince" wrote in message
...
Here is really what I would like:
The original formula is =COUNT(M9:N29)/$K$8

What modification could be used to change the number 29, referring it
to a cell value taken from A3 which is 29.
If A3 changed to the number 30. the formula would read =COUNT(M9:N30)/
$K$8