Summing 2 columns cells into a 3rd colums cells
in [General]
|
From: Wayne Cadigan on 13 May 2010 15:15 In Excel 2007, I need the to add data from column L's cells 2-93 with the data from column M's cells 2-93 and have it total in Column N's cells 2-93. I'm hoping that there is an easier way than auto summing each pair of cells. This example is the smallest range that I have to due this with and auto summing is to time consuming. Please if you have a formula that I can use it would be extremly helpful. Just in case you haven't notice I'm still in the learning stages.................. -- Thank You, Wayne Cadigan
From: John WEC on 13 May 2010 15:34 Hi Wayne You can still do this using the auto sum function. Enter the required formula in the first cell, then move your mouse pointer over the bottom right corner of that cell till it turns to a + sign; then click and hold your left mouse button and drag to the bottom of your list and let go of the button. Hey presto, your formula will be copied to all the required cells. Regards John WEC "Wayne Cadigan" wrote: > In Excel 2007, I need the to add data from column L's cells 2-93 with the > data from column M's cells 2-93 and have it total in Column N's cells 2-93. > I'm hoping that there is an easier way than auto summing each pair of cells. > This example is the smallest range that I have to due this with and auto > summing is to time consuming. Please if you have a formula that I can use it > would be extremly helpful. > Just in case you haven't notice I'm still in the learning > stages.................. > -- > Thank You, > Wayne Cadigan
|
Pages: 1 Prev: Custom Function I can use in a formula? Next: Centralized data |