Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bill
 
Posts: n/a
Default cumulative total using two cells

Is it possible to have A1 cumulate to B1, A2 to B2 and so on. Each row would
stand on it's own as each row would be a different line item. I tryed to use
the two cell accumulator A1 to B1 and it worked fine, but when I applied it
to the next row (A2 to B2) and hit enter it recalcuated A1 to B1. I hope
there is a simple way to generate a formual to make this work. I need help.

Thanks

Bill
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Set calculation to manual. Enter all your data in col A
then hit F9 to calculate.

Biff

-----Original Message-----
Is it possible to have A1 cumulate to B1, A2 to B2 and so

on. Each row would
stand on it's own as each row would be a different line

item. I tryed to use
the two cell accumulator A1 to B1 and it worked fine, but

when I applied it
to the next row (A2 to B2) and hit enter it recalcuated

A1 to B1. I hope
there is a simple way to generate a formual to make this

work. I need help.

Thanks

Bill
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
highlight cells to obtain total without using formula? rdavia Excel Discussion (Misc queries) 2 January 18th 05 05:29 PM
Cumulative Total RockyMountains Excel Discussion (Misc queries) 9 January 12th 05 11:03 AM
calculate which cells in column A will give me the total of column Ken Excel Worksheet Functions 4 January 6th 05 06:25 AM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM
In SUM cells the # sign keeps showing instead of total fyremunki Excel Discussion (Misc queries) 3 December 3rd 04 08:13 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"