Sorry my mistake you are correct but for each individual rows without the
others rows added to it.

"Sherry" wrote:

Sorry I am runnig a macro on my worksheet to be able to accumulate totals
that i got from Mcgimpsey site and using this formula. What I want to do is
have accumulative total for each row i need which I have done but it is
adding that row total and the one above it. How do I keep the total in that
row without having it add to the next row as well?


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