what formula do i put for column m = column k minus column l in e.

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.

"jenniss" wrote:

> what formula do i put for column m = column K minus column L
>
> 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.

try
=SUMPRODUCT((E1:E21-F1:F21))
or
=SUM(E:E)-SUM(F:F)
--
Don Guillett
SalesAid Software
donaldb@281.com
"jenniss" <jenniss@discussions.microsoft.com> wrote in message
news:CCA7CD04-A6B2-4F09-BDBF-7D07CF3F6495@microsoft.com...
> 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.

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
> donaldb@281.com
> "jenniss" <jenniss@discussions.microsoft.com> wrote in message
> news:CCA7CD04-A6B2-4F09-BDBF-7D07CF3F6495@microsoft.com...
> > 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.
>
>
>

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
donaldb@281.com
"jenniss" <jenniss@discussions.microsoft.com> wrote in message
news:12798743-6AD6-4429-BFA5-BB240E60CDF7@microsoft.com...
> 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
> > donaldb@281.com
> > "jenniss" <jenniss@discussions.microsoft.com> wrote in message
> > news:CCA7CD04-A6B2-4F09-BDBF-7D07CF3F6495@microsoft.com...
> > > 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.
> >
> >
> >

jeniss

In M1 enter =K1-L1

Move the mouse pointer to the bottom right corner of M1.

You will see a black square lump.

Double-click on that lump to replicate the formula down as far as there is
data in column L.

=K1-L1 will be incremented to =K2-L2 and K3-L3 etc.

Gord Dibben Excel MVP

On Thu, 6 Jan 2005 08:45:04 -0800, "jenniss"
<jenniss@discussions.microsoft.com> wrote:

>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
>> donaldb@281.com
>> "jenniss" <jenniss@discussions.microsoft.com> wrote in message
>> news:CCA7CD04-A6B2-4F09-BDBF-7D07CF3F6495@microsoft.com...
>> > 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.
>>
>>
>>