Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 Sherry Posts: n/a
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"
#2
Posted to microsoft.public.excel.worksheet.functions
 Barb Reinhardt Posts: n/a
Keeping an acculumative total in a row and only that row.

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" wrote in message
...
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"

#3
Posted to microsoft.public.excel.worksheet.functions
 Sherry Posts: n/a
Keeping an acculumative total in a row and only that row.

=(\$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" wrote in message
...
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"

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 08:32 AM.