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

Bryan,
Thanks for the post back, that works almost, but now all the way across the
row is the same total as the last column with data because it ignors blanks,
now if I go to an "IF(AND)" function to only have totals to the last column
with data it also ignors the blank columns. I think I am going in circles.
And it sounds like I can't have it both ways. Any other ideas?

Mike Rogers

"Bryan Hessey" wrote:


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