Sum this - possible/impossible?
Posted by Kristina on January 05, 2001 12:38 PM
I have two fields A1 and B1.
In A1 the value changes, while B1 keeps adding the values entered in field A1.
and after that
I got a few suggestions that enabled me to do the correct calculation in a row, but when I change data in the row beneath, all the rows above of the one that is changing change too.
A2 B2 B1
3 3 5
A3 B3 B1
1 1 6
I would like that all the rows are treated like separate entities; change in one row doesn't influence the data in the row below or above.
Does anybody have any idea how/if this can be done?
If this is impossible to do in Excel, do you have any idea how/what can I do
this in a simple way? (this calculation is intented for worksheet that can
be send as E-mail attachement and will be used by many people)