Sorry Peo But I am not Trying sum a column that goes up and down. I am trying
to have an individual sum for each row that goes across.

"Peo Sjoblom" wrote:

Frankly it's hard to know what you mean since you post a formula but your
subject mentions macros? I believe you need to post a bit more info
but if you want to sum a row sum the row

=SUM(A1:E1)

If you want an accumulator

http://www.mcgimpsey.com/excel/accumulator.html


--

Regards,

Peo Sjoblom



"Sherry" wrote in message
...
It keeps adding all the totals in all of the column. Don't want that. I
want
to keep an individual cumulative total for each row for inventory of that
product.