... I want a sum for each line
and the column on the right (result column)
will contain all the sums I need.

If the earlier interp was quite correct, to achieve the above,
think you could also put in say, X10:
=$A$10*D10+$E$10*H10+$I$10*L10+$M$10*P10+$Q$10*T10
and just copy X10 down to X109
(assuming, like before that you have 100 continuous rows to summate from
row10 down)

This will give you the sum for each line in X10:X109

And then just put in say, X9: =SUM(X10:X109)
to get the total for the lot

... Edit | Fill | Down. .. I end up with all zeroes in the calculations
You probably didn't fix the 5 "constant" cells: A10, E10, I10, M10, Q10
with dollar signs, e.g.: use $A$10 instead of A10
before filling down from row10
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----