Can I use the address function as an argument in another function. For example,

average(A1:address(7,3))

If yes, what is the correct syntax?

=AVERAGE(A1:INDIRECT(ADDRESS(7,3)))

--

Regards,
Nigel
(E-Mail Removed)



"SID" <(E-Mail Removed)> wrote in message
news:75FC54A7-5BCE-402E-8E7C-(E-Mail Removed)...
> Can I use the address function as an argument in another function. For
> example,
>
> average(A1:address(7,3))
>
> If yes, what is the correct syntax?

Well, yes, you can. But strictly speaking this is a question for the other
Excel group, Excel Worksheet Functions
(microsoft.public.excel.worksheet.functions).

Briefly, you'll need the INDIRECT function too; that tells Excel to treat a
text string like "G3" as a cell address. (ADDRESS just creates the text
string.) Like one of these:

=AVERAGE(INDIRECT("A1:G3"))
=AVERAGE(INDIRECT("A1:"&ADDRESS(7,3)))
=AVERAGE(INDIRECT("R1C1:R"&7&"C"&3,FALSE))

There are other possible combinations, depending on whether you want your
row and/or column to depend on the contents of other cell(s). And if you use
the ADDRESS function, be sure and check the documentation on its third parm
regarding absolute or relative row and column numbers.

If you need more help, though, better post the question on the other forum.
Or feel free to email me, if you prefer :-).

--- "SID" wrote:
> Can I use the address function as an argument in another function. For example,
> "average(A1:address(7,3))". If yes, what is the correct syntax?