Mike,

Keep the totals going across the blank columns and, if possible, use
=Sum(B1:B98)+A99 etc, which ignores blanks.

Bryan


Mike Rogers Wrote:
Thanks for the reply Bryan but that does not help with the running total
that
is carried across the bottom of all the columns. Right now if I skip
a
column the rest of the columns have the ole "#VALUE!" error. I am
trying to
keep a running total across the columns even if I skip one (or two).

Mike Rogers

"Bryan Hessey" wrote:


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




--
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