Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
highlight cells to obtain total without using formula? | Excel Discussion (Misc queries) | |||
Cumulative Total | Excel Discussion (Misc queries) | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
In SUM cells the # sign keeps showing instead of total | Excel Discussion (Misc queries) |