How to add columns without changing formula

		Microsoft Office Forums > Microsoft Excel > Excel
How to add columns without changing formula

FAQ

Thread Tools

Display Modes

04-27-2015, 01:55 PM

dmac19

Windows 7 64bit How to add columns without changing formula

Office 2010 64bit

Novice

Join Date: Apr 2015

Posts: 3

How to add columns without changing formula

Hello

I have numbers in 12 columns Jan - Dec. I want to add Jan thru Mar and create an average. Next month I will want to expand this to include Apr data. Currently all the columns contain numbers (Actual and projected) I want to be able to add the actuals only.

For example:

Jan = 10, Feb =20 Mar = 30, Apr =40, etc The columns included in the formula will increase each month. I don't want to edit the formula each month.

Thanks in advance

Attached Files

Excel Question.xlsx (10.1 KB, 12 views)

Last edited by dmac19; 04-28-2015 at 04:57 AM.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with a VLOOKUP formula & two similar, yet non-identical columns of data.	mikey386	Excel	1	12-18-2014 01:59 AM
Changing rows into columns	paapachak	Word Tables	8	01-06-2014 02:44 PM
Unhide Columns and Changing Column Names?	Moira	Excel	1	05-16-2013 03:37 PM
Changing Cell address within a formula	vermont_past	Excel	12	09-21-2012 12:15 PM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 AM.