Hi, I completely missed your message. Sorry 'bout that.

I'll give this a try when I get home. Thanks! :oD

"Bob Davison" wrote in message
...
Put this in cell A6....
=A1-SUMIF(A2:A5,"<0")

"StargateFanFromWork" wrote in message
...
I did find a "dirty" solution that I'm not happy with but that will work
until this problem is resolved. After looking a few times over a couple
of
days, I finally found pertinent info in the archives on how how to do
conditional formatting not only on a text string but to work with a cell
outside the one we're putting the cond form in. This is probably easy
to
most, but I couldn't get anything to work. (I finally figured out it
might
have to do with the order of the cond form and bumped up the formula
with
the different cell source to the first place. Finally it worked!)

With the cond form in place, I then put some zeroes in some of the cells
in
column F. Column G now keeps a proper tally. It would be easier to
have
the formula work properly, but at least this cumbersome work-around
"erases"
the results in any cell even only if on the screen in G that has a zero
preceding it in F. That way any repeating dollar amounts are wiped out
and
I only see the proper tallies. The printout doesn't work because the
colours don't hide in a black and white printout but I'll try changing
to
greyscale colours for the affected cells to see if I get the same
results
in
the printout as on the screen, that is, of hiding certain dollar values.

At any rate, I'm still interested if there is a way to make the formula
work
even with cells that have no input. As mentioned originally, any empty
cells disrupt the tallies and I get blanks from the point after the very
first empty cell.

TIA.

"StargateFanFromWork" wrote in message
...

[snip]

With the formula as it stands, A6 gives the result of 90 no matter
what is happening in A2 to A5 as long as one value is in any of these
cells.
Deleting any of those cell contents didn't affect the results, in other
words.

A1 = 100 (subtract from)
A2 = 10
A3 = 10
A4 = 10
A5 = 10
A6 = 60
This is the type of result I was hoping to achieve. I'm very sorry
that
it
was so tough to explain. I should have just given an example like
this.
Hopefully XL2K can work with an adjusted formula to give the above type
of
result, or like below, depending on the cell contents even when some
are
empty.

A1 = 100 (subtract from)
A2 =
A3 = 10
A4 =
A5 = 10
A6 = 80

A1 = 100 (subtract from)
A2 = 10
A3 = 10
A4 = 10
A5 =
A6 = 70


A1 = 100 (subtract from)
A2 =
A3 =
A4 =
A5 =
A6 = 100

Can this be done?

Thanks. :oD

[snip]