I'm pretty sure we can solve this.

Can you post a small snippet of data and tell me what result you expect. Be
very specific as to where the data is located. The more details you provide
the easier it is for us to understand what you're trying to do.

--
Biff
Microsoft Excel MVP


"sjm182" wrote in message
...
True, but if the bottom cells have data in them, it will divide the 2 sums
giving an inaccurate number based on the current data. I think I'm asking
too much of Excel, but thanks for the attempts!

"T. Valko" wrote:

Does that make sense?

SUM ignores empty cells so how do the empty cells affect the formula? If
you
have:

10...5...2...empty...empty...empty...empty to the end of the row

The sum of that row is 17 no matter how many empty cells there are after
the
last entry.

--
Biff
Microsoft Excel MVP


"sjm182" wrote in message
...
I am figuring a running total where the bottom row is the required hours
(known ahead of time) and the top row is actual hours (entered daily).
If
I
include all of the cells in the range with a blank on the top row, it
totals
the % hours fulfilled wrong because it looks as if all the blank rows
are
zeros; I'm also figuring a running total of the difference between the
two
totals as the hours are filled and this is also wrong if it counts the
blanks. Does that make sense? I think I'm being quite difficult
without
meaning to be :-)

"T. Valko" wrote:

because there is data in the bottom row,
but not the top, the answer it returns is incorrect.

I don't understand how that could cause the formula to return an
incorrect
result?

--
Biff
Microsoft Excel MVP


"sjm182" wrote in message
...
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.




.



.



.