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-28-2015, 07:18 AM

Pecoflyer

Windows 7 64bit How to add columns without changing formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,919

Pecoflyer has a reputation beyond repute

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

« 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 10:23 AM.