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

Tyro

"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.- Hide quoted text -

- Show quoted text -

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"