|
|
#1
04-27-2015, 01:55 PM
|
|||
|
|||
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 Last edited by dmac19; 04-28-2015 at 04:57 AM. 
|
|
#2
04-28-2015, 02:04 AM
|
||||
|
||||
|
Please post a sample sheet. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
04-28-2015, 07:18 AM
|
||||
|
||||
|
After replacing semi-colons with commas try
Code:
=SUM($C$8:INDEX($C$8:$N$8;;MATCH(TEXT(EOMONTH(TODAY();0);"mmm");$C$7:$N$7;0)))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
