Specifying a range using cell values



I'm trying to sum a range of cells, but I want to use cell values to specify what range to sum.

I've tried:

sum(address(A1,2):address(A2,2))

but this only gives me a syntax error. I've also looked at the offset function, but I can't find any examples and I have yet to construct an offset statement that doesn't result in a syntax error.

Thanks for the help,
Brad




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]