software

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

www.mcgimpsey.com/excel/accumulator.html--

Regards,

Peo Sjoblom
quot;Sherryquot; gt; wrote in message
...
gt; It keeps adding all the totals in all of the column. Don't want that. I
want
gt; to keep an individual cumulative total for each row for inventory of that
gt; product.
gt;
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?quot;Peo Sjoblomquot; wrote:

gt; Frankly it's hard to know what you mean since you post a formula but your
gt; subject mentions macros? I believe you need to post a bit more info
gt; but if you want to sum a row sum the row
gt;
gt; =SUM(A1:E1)
gt;
gt; If you want an accumulator
gt;
gt; www.mcgimpsey.com/excel/accumulator.html
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt;
gt; quot;Sherryquot; gt; wrote in message
gt; ...
gt; gt; It keeps adding all the totals in all of the column. Don't want that. I
gt; want
gt; gt; to keep an individual cumulative total for each row for inventory of that
gt; gt; product.
gt; gt;
gt;
gt;
gt;

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.

quot;Peo Sjoblomquot; wrote:

gt; Frankly it's hard to know what you mean since you post a formula but your
gt; subject mentions macros? I believe you need to post a bit more info
gt; but if you want to sum a row sum the row
gt;
gt; =SUM(A1:E1)
gt;
gt; If you want an accumulator
gt;
gt; www.mcgimpsey.com/excel/accumulator.html
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt;
gt; quot;Sherryquot; gt; wrote in message
gt; ...
gt; gt; It keeps adding all the totals in all of the column. Don't want that. I
gt; want
gt; gt; to keep an individual cumulative total for each row for inventory of that
gt; gt; product.
gt; gt;
gt;
gt;
gt;

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

quot;Sherryquot; wrote:

gt; Sorry I am runnig a macro on my worksheet to be able to accumulate totals
gt; that i got from Mcgimpsey site and using this formula. What I want to do is
gt; have accumulative total for each row i need which I have done but it is
gt; adding that row total and the one above it. How do I keep the total in that
gt; row without having it add to the next row as well?
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Frankly it's hard to know what you mean since you post a formula but your
gt; gt; subject mentions macros? I believe you need to post a bit more info
gt; gt; but if you want to sum a row sum the row
gt; gt;
gt; gt; =SUM(A1:E1)
gt; gt;
gt; gt; If you want an accumulator
gt; gt;
gt; gt; www.mcgimpsey.com/excel/accumulator.html
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Sherryquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; It keeps adding all the totals in all of the column. Don't want that. I
gt; gt; want
gt; gt; gt; to keep an individual cumulative total for each row for inventory of that
gt; gt; gt; product.
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;