Summing 2 columns cells into a 3rd colums cells

  • Thread starter Thread starter Wayne Cadigan
  • Start date Start date
W

Wayne Cadigan

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..................
 
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
 
Back
Top