Michelle Konzack wrote:
Hello Michael,
Am 2010-04-04 22:05:05, hacktest Du folgendes herunter:
Just clarifying, you want something like this?
B2 =(C2+D2)*F2
B3 =(C3+D3)*F3
B4 =(C4+D4)*F4
B5 =(C5+D5)*F5
B6 =(C6+D6)*F6
B7 =(C7+D7)*F7
B8 =(C8+D8)*F8
Yes...
If so, it can be achieved by mouse-dragging the formula as shown
under 'Copying Formulae' in help. If this is not what you mean i for one
would need more information.
You realy mean, I should copy arround 80.000 fields by hand? Thats sick!
In Micr0$oft Excel you define it one time and if you are in the next
line it is automaticaly there...
the sameis, I have not found a function "=SUM(over)", which mean,
calculate the SUM of any values of the fields on the top of THE CURRENT
field.
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
There are two possibilities to how to solve this problem.
First is to enter a number or letter into column A beginning with row 2
all the way down to the last row you want to enter the formula. Then in
B2 enter this formula:
=(C2+D2)*F2
Select cell B3 and then B2. A box surrounds B2 with a handle on its bottom
right. Double click the hangle, and the formula is copied into the cells of Col
B down to the last row you want the formula entered. Now, if you have data in
Col C in all of the rows, you could just enter the formula in B2 and double
click the handle once you have deselected and selected B2.
As far as "=SUM(over)" is concerned, what is wrong with entering =SUM(#@:#&)
Where # is the column, @ is the first row you want to sum, and& is the last row you want to
sum? There is not that much difference.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
