close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()