ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   A1=A1+B1 =? (https://www.excelbanter.com/excel-discussion-misc-queries/217677-a1%3Da1-b1-%3D.html)

qwertqwert

A1=A1+B1 =?
 
Hi I am useing *Office 2007 . I want to get the totalize of A1+A2 charts
towards the A1 chart. Then, when I enter data to the B1 chart , I want the
value of A1 chart to sum up the new value of B1 chart. Namely, all the datas
will be entered to the B1 chart and their total will be displayed in A1 chart.
Örnek:A1=A1+B1
A1 B1
1st data 5 5
2nd data 8 3
3rd data 10 2


Sheeloo[_3_]

A1=A1+B1 =?
 
In A1 enter
=B1
In A2 enter
=B2+A1

Select A2
and copy over A3:A100 or whatever.

"qwertqwert" wrote:

Hi I am useing *Office 2007 . I want to get the totalize of A1+A2 charts
towards the A1 chart. Then, when I enter data to the B1 chart , I want the
value of A1 chart to sum up the new value of B1 chart. Namely, all the datas
will be entered to the B1 chart and their total will be displayed in A1 chart.
Örnek:A1=A1+B1
A1 B1
1st data 5 5
2nd data 8 3
3rd data 10 2


Niek Otten

A1=A1+B1 =?
 
Not recommended. But if you insist:

http://www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"qwertqwert" wrote in message
...
Hi I am useing *Office 2007 . I want to get the totalize of A1+A2 charts
towards the A1 chart. Then, when I enter data to the B1 chart , I want the
value of A1 chart to sum up the new value of B1 chart. Namely, all the
datas
will be entered to the B1 chart and their total will be displayed in A1
chart.
Örnek:A1=A1+B1
A1 B1
1st data 5 5
2nd data 8 3
3rd data 10 2



All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com