Thread: [Solved] How to add columns without changing formula
View Single Post
 
Old 04-27-2015, 01:55 PM
dmac19 dmac19 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Apr 2015
Posts: 3
dmac19 is on a distinguished road
Default 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
File Type: xlsx Excel Question.xlsx (10.1 KB, 12 views)
Last edited by dmac19; 04-28-2015 at 04:57 AM.
Reply With Quote