Hi again,

Ok I have added another expense column before the actual Expense Column to
reflect PayPal Deductions from the Donations and have been working to figure
out the formula and I cannot get it to work. My columns are as Follows:

A) Date
B) Description
C) Donations - Income
D) Registration - Income
E) Special Events - Income
F) PayPal Fees - Expense
G) Normal Expenses
H) Balance

I am using the formula that T. Valko posted.

Any help would be much appreciated.

Thanks in advance.

LowRider




"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LowRider" wrote in message
...
Thanks Biff. Worked like a charm.

Very much appreciated.

LowRider





"T. Valko" wrote:

Try this:

=IF(COUNT(C4:G4),SUM(C4:F4)-G4+H3,"")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"LowRider" wrote in message
...
Hi all,

New here and would like some help. Since I am a very very basic user
of
Excel I created a sheet to track our Membership Finances. This is what
I
have.

A B C D E
F G
Date Description/Member Name Inc1 Inc2 Inc3 Expense
Balance
1/1/07 TEST1 10 10
5
15
1/2/07 TEST2 10
4 21

21

21

21

From the example of above I am using this formula and I know it is
wrong
probably or something even simplier but not sure what it would be
=SUM(C4+D4+E4+F4-G4+H3) but I want to be able to hide ALL the 21's
going
down
the page as I did fill the other Cells in G all the way down to row
100.

Is there anyway of doing this?


Thanks Much In Advance and Please FORGIVE me for my Formula I know it
is
real basic, LOL.

LowRider