What I have is just a simple @SUM all the way down one column, until the
spreadsheet is completed most of the cells show zeros. The big guy doesn't
want to see the zeros "if there is no data I don't want to see anything.
Well there is no data today but there will be tommorow I don want to have to
cut and paste all these every day.

Does that help

"davesexcel" wrote:


Give us an example of the formulas you are using


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522146