add cell to array formula

[RickeyS]

I'm sure this is a simple thing to do but I can't figure it out. I have an array formula that is in cells A2:A8. I want to include A9 in this array how do I do this? I keep getting you can't change part of an array message.

Thanks alot,
Rick

 

[barry houdini]

You need to delete the whole range.

Then re-input revised formula in A2, select A2:A9 and press
CTRL+SHIFT+ENTER