Formula result or Value as part of a range ... ???

[miguems]

Hello:

I need to define a range in a macro that I apply to different size spreadsheets and I need one of the values to be a formula result or the value of a cell, I'll use SUM as an example: instead of SUM(A1:K200) I need something like SUM(A1: (=COUNTIF(data, "<>""") + 5) or just
SUM(A1: Value(Z1)) where Z1 contains the result of a formula.

Can this be done?

Thanks in advance.

M.

 

[Andrew Poulsom]

Like this?

=SUM(A1:INDEX(A:A,Z1))

 

[miguems]

[b]Thank you!![/b]

That's exactly what I needed. I had the syntax wrong so now I was able to use it in an SUMIF and also Range. The macro works great now.

Thanks again!!!

Miguel.