You're welcome. It will save you asking later how you can hide all the
zeros <g

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"DeeDeeCee" wrote in message
...
Thank you Sandy. I think Stan's solution will be easier for me and I'll
have
to live with the less-appealing visual appearance of the table till I'm a
little more advanced with the formula-making. But I'll copy this down in
my
Excel notes for use then.

"Sandy Mann" wrote:

"Stan Brown" wrote in message
t...
I don't understand Sandy's solution because I can't see any need for
a COUNT function.

The purpose of the COUNT() function is to check if there are any entries
in
that row and if not, return an empty string. Just makes it look better
that
a whole column of zeros when there are no entries in those rows.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Stan Brown" wrote in message
t...
Mon, 3 Sep 2007 01:46:01 -0700 from DeeDeeCee
:
I'm making a table to keep track of deposits, credits, etc for a bank
account, with a running balance. Here is the basic layout:
Column b = date of entry
Column c = credits
Column d = deposits
Column e = bank fees
[ Column F & G = other info, not relevant here ]
Column H = Running balance

But for each entry, only 1 of C-D-E will have a number-value for a
given
entry. I'd like to have column H look at c, d, and e and add or
subtract
whichever one has info in it from the previous cell in Column H. I was
thinking that I could make H have a formula that would say "Subtract
the
sum-total of C-D-E from the previous cell". But I can't figure out how
to
do
this. Any relatively easy way to do this, or otherwise achieve my goal
of
a
running balance that auto-corrects as I add/delete entries over time?

I don't understand Sandy's solution because I can't see any need for
a COUNT function.

To me it seems pretty straightforward to put the starting balance in
H2 and this in H3:
=H2 + C2 + D2 - E2
and then click and drag that formula down column H.

Incidentally, did you mean column C to be "credits" in the accounting
sense, meaning that they would reduce the total of cash on hand? In
that case the formula would be
=H2 - C2 + D2 - E2

--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/