ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Summing 2 columns cells into a 3rd colums cells (https://www.excelbanter.com/excel-discussion-misc-queries/263740-summing-2-columns-cells-into-3rd-colums-cells.html)

Wayne Cadigan

Summing 2 columns cells into a 3rd colums cells
 
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

John WEC

Summing 2 columns cells into a 3rd colums cells
 
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



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com