![]() |
#1
|
|||
|
|||
![]() 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
|
||||
|
||||
![]()
Please post a sample sheet. Thx
__________________
Using O365 v2503 - 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 |
#3
|
|||
|
|||
![]()
sorry file attached
Thanks |
#4
|
||||
|
||||
![]()
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)))
__________________
Using O365 v2503 - 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 |
#5
|
|||
|
|||
![]()
Thanks - that worked. Swapped out the Today() function with a cell reference that allows me to change the dates
thanks again |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mikey386 | Excel | 1 | 12-18-2014 01:59 AM |
![]() |
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 |
![]() |
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |