Home 
Search 
Today's Posts 
#1




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




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




try
=SUMPRODUCT((E1:E21F1: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. 
#4




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:E21F1: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. 
#5




if you want =e1f1 in col M then do that. If you want e2f2 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:E21F1: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




jeniss
In M1 enter =K1L1 Move the mouse pointer to the bottom right corner of M1. You will see a black square lump. Doubleclick on that lump to replicate the formula down as far as there is data in column L. =K1L1 will be incremented to =K2L2 and K3L3 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:E21F1: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 
Display Modes  


Similar Threads  
Thread  Forum  
Combine candle and line in a single chart  Charts and Charting in Excel  
Formula Again  Excel Discussion (Misc queries)  
Aligning Two Lists in Excel  Excel Discussion (Misc queries)  
How do I sort a column of formulas in Excel?  Excel Discussion (Misc queries)  
How do I sort a column of formulas in Excel?  Excel Discussion (Misc queries) 