ExcelBanter - Hide Cell Information

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hide Cell Information (https://www.excelbanter.com/excel-worksheet-functions/163734-hide-cell-information.html)

Hide Cell Information

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

Hide Cell Information

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

Hide Cell Information

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

Hide Cell Information

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

Hide Cell Information

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

Hide Cell Information

Try this:

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

--
Biff
Microsoft Excel MVP

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