# Totalling non consecutive columns

## Excel Help for Totalling Non Consecutive Columns in Analyzing Corporate Financial Data

### Totalling Non Consecutive Columns

Rate this:
(3/5 from 1 vote)
 In my biz plan the financial are update with two new cols each year.I need to total a1+c1+d1+f1 this year and next year we add two new cols g & h is there a slick way to total these cols as the formula is used in bunch of cells without editing each one or copying for hours?Thanks Rod Dakan Posted by rdakan on 11 Mar 2009
 Replies - Displaying 1 to 4 of 4 Order Replies By: Most recent | Chronological | Highest Rated
 Rate this: (3/5 from 1 vote) Thanks RussellI did make a small change to my range to allow for the copying down.When I selected the cells to total excel made them fixed with the \$ so all I had to do to make it mobil was remove the \$ for the row.Works great now Rod Rod Dakan Posted by rdakan on 13 Mar 2009
 Rate this: (3/5 from 1 vote) Once you created the formula in the first row, you should be able to copy it down the column to total each row in the spreadsheet. Excel Business Forums Administrator Posted by Excel Helper on 12 Mar 2009
 Rate this: (3/5 from 1 vote) RussellThat works fine.  ThanksNow is there a way to use that range name to total across row 2 and so forth down the income statement? Rod Dakan Posted by rdakan on 12 Mar 2009
 Rate this: (3/5 from 1 vote) You should name the ranges that you want to sum together by selecting the range of cells and create a name in the Name box in the top left corner.  e.g "total1"You can then use this name to create a formula like "=SUM(total1)".If you are adding columns it is best to make the named range with one empty column at the end.  This way, inserting new columns will update the named range reference to update the formula result.For non consecutive columns you should be able to update the first row formula and then autofill or copy for the rest of the columns. Excel Business Forums Administrator Posted by Excel Helper on 11 Mar 2009
 Displaying page 1 of 1

 Find relevant Excel templates and add-ins for Totalling non consecutive columns in the Excel Business Solutions Directory