INDIRECT is not really intuitive (at least not to me). It usually takes me a
bit of trial=and-error.
Try:
=INDIRECT("I"&ROW())-INDIRECT("P"&ROW())
and:
=INDIRECT("D"&ROW())/INDIRECT("A"&ROW())
--
Vasant
"spackler" wrote in
message ...
Great. Awesome. Perfect. Thanks Vasant!
Now I'm trying to do the same thing with =I2-P2 and =D2/A2 and having
no luck adapting what you gave me above for the SUM.
For the subtraction I was trying :
=SUM(INDIRECT("I"&ROW()&"-P"&ROW()))
or
=(INDIRECT("I"&ROW()&"-P"&ROW())) with no luck.
I have not tried the division yet as I realize my function
understanding is lacking...
Suggestions?
Thanks.
--
spackler
------------------------------------------------------------------------
spackler's Profile:
http://www.excelforum.com/member.php...o&userid=26212
View this thread: http://www.excelforum.com/showthread...hreadid=395191