Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 05, 05:17 PM
jenniss
 
Posts: n/a
Default 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.

  #2   Report Post  
Old January 6th 05, 05:21 PM
jenniss
 
Posts: n/a
Default



"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.

  #4   Report Post  
Old January 6th 05, 05:45 PM
jenniss
 
Posts: n/a
Default

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.




  #6   Report Post  
Old January 6th 05, 09:18 PM
Gord Dibben
 
Posts: n/a
Default

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"
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

"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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine candle and line in a single chart Bert Charts and Charting in Excel 4 January 19th 05 08:23 AM
Formula Again GBH99 Excel Discussion (Misc queries) 2 December 13th 04 04:21 PM
Aligning Two Lists in Excel Rich Excel Discussion (Misc queries) 2 December 4th 04 06:44 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 02:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 04:19 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017