if you want =e1-f1 in col M then do that. If you want e2-f2 then grab the
fill handle in cell m1 and copy down.

--
Don Guillett
SalesAid Software

"jenniss" wrote in message
...
no doesnt work i know the formula is correct its just that it is putting
the
formula in cell M1 rather than the whole of column M

"Don Guillett" wrote:

try
=SUMPRODUCT((E1:E21-F1:F21))
or
=SUM(E:E)-SUM(F:F)
--
Don Guillett
SalesAid Software

"jenniss" wrote in message
...
what formula do i put for column m = column k minus column

i have tried to do it by put the curser on the colmn so it highlightes
all
the fields but this results in having the answer in row m1 and doesnt
update
all the rows.