Thanks!!

"Max" wrote:

Maybe better to make the cell refs (D2:E2) absolute,
in case you're copying across, so try instead, array-entered:
=SUM(LINEST(A$3:A$6,B$3:B$6)*$D$2:$E$2)
Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----