Thanks, I tried that, but because there is data in the bottom row, but not
the top, the answer it returns is incorrect. I dont' even know if what I"m
asking is possible - I want to create a form that I can share with others to
use, but I dont' want to have to instruct them to update the formula each
time you add in a new value.

"T. Valko" wrote:

If there's no other numerical data beyond the last entry to the end of the
row just expand the range:

=SUM(AI49:IV49)-SUM(AI48:IV48)

--
Biff
Microsoft Excel MVP


"sjm182" wrote in message
...
I'm not sure if I'm asking this correctly, so please help me clarify if
needed!

first example:
=SUM(AI49:AN49)-SUM(AI48:AN48) in which "AN" is regularly extended (AO,
AP,
etc.).
How can I create a formula that gives me an answer when cell 49 is
standard
and cell 48 is continuously updating? Currently, I am manually changing
"AN"
to "AO", and so on as I update the information.

second example:
=SUM(AI48:AN48)/SUM(AI49:AN49) with the same situation as above.




.