Can I use the address function as an argument in another function?

  • Thread starter Thread starter SID
  • Start date Start date
S

SID

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 :-).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optional argument as Variant not acting like number 4
sub or function argument 5
Range Arguments 1
How to write a VBA function which returns an integer 5
User defined function 5
SUMIF and SUMIFS Error 3
Autocomplete Custom Functions and functions arguments 1
Capture cell address in UDF 4

Back
Top