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