Daniel Rentz wrote:
> =AVERAGE(INDIRECT("c"&A2&":c"&b2))
will do the trick.
It sure did, thanks! One more question if you don't mind...I also use a similar equation in which I specify the row and the column from values in other cells. Like this:
=AVERAGE(INDIRECT(DB$1&$AV2):INDIRECT(DB$1&$AW2)) Based on your solution above I thought I had the logic and wrote:=AVERAGE(INDIRECT(DB$1&$AV2&":"&DB$1&$AW2)) but that gives me error 502. DB1 contains the letters that specify a column, and top and bottom rows are specified in av2 and aw2. Any suggestions?
Thanks, Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
