Hi, Hate to bother every1, just have a quick question regarding a excel formula. Im using a lot of =sum formulas, i was just wondering in my total figures, is there any chance i can have the display value show nothing if there was no other data entered. Eg on my total page, if no data was entered on other pages, shows a 0. Its fine...but i prefer instead of 0 it just don't show anything. Possible? If at first you don't succeed, simply give up and let me do it!!!

If you all ready have the formula in place, you can go into Excel Options and in there ucheck "show zero values". This will affect all spreadsheets in Excel however. you can also add something like this if (Xxx<1,"") Where X is the Column and xx is the cell number.

Let's say your sum total was for A1:A6 Use the following in A7: =IF(SUM(A1:A6)<>0,SUM(A1:A6)," ") Meaning if the sum of a1 thru a6 is greater than or less than 0 then sum of a1:a6 else blank. HTH Bryan Edit: Had left off the last closing parenthesis on the end of the formula.