Hi I've asked this before and here i go again. I am new with Excel so bear
with me.
I would like to keep an accumulative total for my rows without having my
rows add to each other in that column. I would like to make an simple
inventory sheet for my
employer.
Products Amount Sold Total
Spread cellB4 1 cell C4 1
Jams cell B5 3 cell C5 3
The Formulas I haved used for these cells are =($B$4 C4) and =($B$5 C5) what
it does is give the total (quot;greatquot;) but then continues to add the other cell
values to it.
I would like it to keep the row total only. Is there any way? quot;Helpquot;
I'm not clear on the problem when you say it adds other cell values to it.
Try this:
Turn on the display of the formulas by going to TOOLS -gt; OPTIONS -gt;VIEW and
check FORMULAS
Copy the cells that you are having difficulty with here.
That may help us.
quot;Sherryquot; gt; wrote in message
...
gt; Hi I've asked this before and here i go again. I am new with Excel so bear
gt; with me.
gt; I would like to keep an accumulative total for my rows without having my
gt; rows add to each other in that column. I would like to make an simple
gt; inventory sheet for my
gt; employer.
gt; Products Amount Sold Total
gt; Spread cellB4 1 cell C4 1
gt; Jams cell B5 3 cell C5 3
gt; The Formulas I haved used for these cells are =($B$4 C4) and =($B$5 C5)
gt; what
gt; it does is give the total (quot;greatquot;) but then continues to add the other
gt; cell
gt; values to it.
gt; I would like it to keep the row total only. Is there any way? quot;Helpquot;
=($B$4 C4)
=($B$5 C5)
=($B$6 C6)
These are the formulas. The thing is I don't want them to add to each other
as well.
quot;Barb Reinhardtquot; wrote:
gt; I'm not clear on the problem when you say it adds other cell values to it.
gt; Try this:
gt;
gt; Turn on the display of the formulas by going to TOOLS -gt; OPTIONS -gt;VIEW and
gt; check FORMULAS
gt;
gt; Copy the cells that you are having difficulty with here.
gt;
gt; That may help us.
gt;
gt;
gt;
gt; quot;Sherryquot; gt; wrote in message
gt; ...
gt; gt; Hi I've asked this before and here i go again. I am new with Excel so bear
gt; gt; with me.
gt; gt; I would like to keep an accumulative total for my rows without having my
gt; gt; rows add to each other in that column. I would like to make an simple
gt; gt; inventory sheet for my
gt; gt; employer.
gt; gt; Products Amount Sold Total
gt; gt; Spread cellB4 1 cell C4 1
gt; gt; Jams cell B5 3 cell C5 3
gt; gt; The Formulas I haved used for these cells are =($B$4 C4) and =($B$5 C5)
gt; gt; what
gt; gt; it does is give the total (quot;greatquot;) but then continues to add the other
gt; gt; cell
gt; gt; values to it.
gt; gt; I would like it to keep the row total only. Is there any way? quot;Helpquot;
gt;
gt;
gt;
- Mar 09 Fri 2007 20:36
Keeping an acculumative total in a row and only that row.
close
全站熱搜
留言列表
發表留言