Hi Mike,

When I said copy across the row, I should have said only as far as you
feel is necessary. If any column is blank (including at the end), the
total shouldn't appear, so I don't understand the need for conditional
formatting.

Having said that, if you're happy, I'm happy - however you've achieved
that - and I'm glad you're back in the saddle.

Bryan and I both appreciate your feedback.

Cheers,


Mike Rogers Wrote:
John, Bryan,
Guys you did great! I took a little of what you where both saying and
made
it work. The Sum formula worked and does ignor blanks, but it also
carries
the total of the last column totaled all the way to the right edge of
my work
sheet, did not like that! So I referenced the total cell with
conditional
formating and said if this cell is <.25 ((a reference number that will
always
be less than anything in the column)) then formate the continious total
with
white font. Picked it up with the format painter and finished the row
out.
Then I grouped all 20 worksheets and made them all work right, so now
thanks
to you guys I am back in the saddle again. Thanks again for the help.

Mike Rogers

"John James" wrote:


Mike,

OK. Now I understand what you mean (I think). Try this. In F18,
enter:
=IF(F17="","",SUM($A17:F17))

Then copy across the row.


--
John James

------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=531714




--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531714