You could use Conditional Format on the column totals, such that if the
count of this column items = zero then the text is white-on-white (ie,
hidden)

This will accomodate the entries in the column totaling zero, and will
allow the appearance of totals for only the columns with entries.

HTH


Mike Rogers Wrote:
I have data that is entered into each column by different people. Each
column is totaled. Below the column total is a running total with
each
column added to the last. The formula used for that column is:
=IF(AND(E18,F17),E18+F17,""). What I need is that if a column or even
two is
not filled in I need the total, basically skipping the empty columns.
Is
this possible?
Thanks for any help offered!!!

Mike Rogers


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531714