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

Those look to be working, thanks again!


--
spackler
------------------------------------------------------------------------
spackler's Profile: http://www.excelforum.com/member.php...o&userid=26212
View this thread: http://www.excelforum.com/showthread...hreadid=395191