Keeping an acculumative total in a row and only that row.

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 ("great") 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? "Help"

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 -> OPTIONS ->VIEW and
check FORMULAS

Copy the cells that you are having difficulty with here.

That may help us.



"Sherry" <[email protected]> wrote in message
news:[email protected]...
> 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 ("great") 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? "Help"

=($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.

"Barb Reinhardt" wrote:

> 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 -> OPTIONS ->VIEW and
> check FORMULAS
>
> Copy the cells that you are having difficulty with here.
>
> That may help us.
>
>
>
> "Sherry" <[email protected]> wrote in message
> news:[email protected]...
> > 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 ("great") 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? "Help"
>
>
>