Using INDIRECT
Will do. Thanks.
On Jan 9, 7:02 pm, "Tyro" wrote:
We will be here for you, fried brains and all. Do us a favor and post your
messages at the top of your post, not at the bottom. :)
Tyro"rhhince" wrote in message
...
On Jan 9, 1:13 pm, "Tyro" wrote:
Use a named range
Tyro
"rhhince" wrote in message
...
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"- Hide quoted
text -
- Show quoted text -
Thanks everyone for your input. My brain is fried for the moment.
Easier to manually change for now.
Ray
|