Hide Cell Information

[Guest]

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

 

[T. Valko]

Try this:

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

Copy down as needed.

 

[Guest]

Thanks Biff. Worked like a charm.

Very much appreciated.

LowRider

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Guest]

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]

Try this:

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