Dont show sum value until sheet is in use

[ipbr21054]

Hi,
I have several sheets as example,
Income 1,Income 2,Income 3, Expenses 1,Expenses 2,Expenses 3 etc etc

So at the start of each month i will be adding values on sheet Income 1 & Expenses 1 until that sheet is complete then i move over to say Income 2 etc.

Until i move over all the other sheets in cell K33 will show a value because the code in that cell is as follows,

=IF(SUM(INCOME1!G32 -EXPENSES7!K32)-MILEAGE!C32=0,"",SUM(INCOME1!G32 -EXPENSES7!K32)-MILEAGE!C32)

So can cell K33 show nothing until i start to use that sheet in question,i mean if cell A4 is empty then K32 shows nothing but if cell A4 has a value then allow cell K33 to show its value.

Make sense ??

Thanks

 

[Yongle]

How about wrapping another condition around your current formula in both K32 and K33
=IF(A4="","",CURRENT FORMULA WITHOUT =)

 

[ipbr21054]

Hi,
How would i go about doing that as currently,
Cell K32 has

=SUM(D30:F30:G30:H30:I30:J30:K30)

Cell K33 has

=IF(SUM(INCOME1!G32 -EXPENSES2!K32)-MILEAGE!C32=0,"",SUM(INCOME1!G32 -EXPENSES2!K32)-MILEAGE!C32)

where or how should i apply what you have advised.

Thank

 

[Yongle]

formula in K32 becomes
=IF(A4="","",SUM(D30:F30:G30:H30:I30:J30:K30))

Apply the same technique to the formula in K33

 

[ipbr21054]

Hi,

Would this be correct,I asked because i get a message to say too many arguments for this function ???

WAS

=IF(SUM(INCOME1!G32 -EXPENSES2!K32)-MILEAGE!C32=0,"",SUM(INCOME1!G32 -EXPENSES2!K32)-MILEAGE!C32)

NOW

=IF(A4="","", SUM(INCOME1!G32 -EXPENSES1!K32)-MILEAGE!C32=0,"",SUM(INCOME1!G32 -EXPENSES1!K32)-MILEAGE!C32))

 

[Yongle]

You need to include the WHOLE of your original formula
=IF(A4="","", IF(SUM(INCOME1!G32 .....

 

[ipbr21054]

Ok thanks.

I have now entered it like so.

=IF(A4="","",IF(SUM(INCOME1!G32-EXPENSES1!K32)-MILEAGE!C32=0,"",SUM(INCOME1!G32-EXPENSES1!K32)-MILEAGE!C32))