ExcelBanter - cell ref w/ varaibiles

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - cell ref w/ varaibiles (https://www.excelbanter.com/excel-programming/311240-cell-ref-w-varaibiles.html)

dave h

cell ref w/ varaibiles

Can you make a function ie: Sum(a5:a10),
have the a5 and a10 as individual "cell" variables in
order to change your function very fast by typing numbers
into two "VARIABLE" cell ranges for the functions address
for example:

CELL B1 CELL B2
15 25

Then:

SUM(A&"+b1":A&"+b2")???
Have your cell refs as varaibles to change the formula
very fast?

Frank Kabel

cell ref w/ varaibiles

Hi
=SUM(INDIRECT("A" & B1 & ":A" & B2))

--
Regards
Frank Kabel
Frankfurt, Germany

dave h wrote:
Can you make a function ie: Sum(a5:a10),
have the a5 and a10 as individual "cell" variables in
order to change your function very fast by typing numbers
into two "VARIABLE" cell ranges for the functions address
for example:

CELL B1 CELL B2
15 25

Then:

SUM(A&"+b1":A&"+b2")???
Have your cell refs as varaibles to change the formula
very fast?

All times are GMT +1. The time now is 04:14 AM.