Using a cell address that is listed in one cell, as the beginning or end of a range in another cell's formula.

[lolivieri]

I have used the Cell "address" formula with nested Index and Match formulae to return a cell location address. This formula (in cell AA7) returns a value of $Q$12, a location I need to use. In another cell I'd like to count non-blank cells in a range that ends with $Q$12 (i.e. G12:$Q$12). How can I use the returned cell location in cell AA7 to generate the end of my calculation range?

I hope I asked that clearly enough. Searches have not yielded results (though, it's admittedly hard verbalize). Thanks for the help.

 

[JoeMo]

Use this range: G12:INDIRECT(AA7)

For example: =SUM(G12:INDIRECT(AA7))

 

[lolivieri]

Use this range: G12:INDIRECT(AA7)

For example: =SUM(G12:INDIRECT(AA7))

Thank you, JoeMo! I tried the INDIRECT formula, but probably had the syntax wrong somehow. I'll try it Monday when I'm back at work. Thanks again.