On Jan 21, 10:00*pm, JLGWhiz
wrote:
The answer I get is 15 base on the example posted. *The reason A4 will not
change is because it is a string in quotation marks and not a cell address
string.

The cells your formula is adding is A4 and A3. *B4 = C4 is 4 - 1 = 3
That make your formula readSum(Indirect("A4:A3")
Since you only have integers in column A, the Indirect is superfluous here. *
You could just as well use =a4 + a3.

Maybe you need to look at the help file for the Indirect fundcion again to
understand how it works.


Yea, I was trying to understand the examples in Indirect. Then I had
to find out what superfluous meant. Thanks anyway.