I have three columns of data for each month. I have concatenated each month name with column name now my columns names looks like
我每个月有三列数据。我已将每个月的名称与列名联系起来，现在我的列名称看起来像
ST41804
SVYM total41804
For example, Now i have to find out the sum of column SVYM total in june month. i ll find the location of the column by using the formula (i.e.MATCH(CONCATENATE("SVYM Total","Jun-14"),Array,0).
例如，现在我必须找出6月份列SVYM总和的总和。我将通过使用公式（即MATCH（CONCATENATE（“SVYM Total”，“Jun-14”），Array，0）找到列的位置。
Now how to add all the values of the column which i found out by using match formula.
现在如何使用匹配公式添加我发现的列的所有值。
1 个解决方案
#1
1
You can use something like this:
你可以使用这样的东西：
=SUM(INDEX(A4:Z100,0,MATCH("SVYM Total" & "Jun-14",Array,0)))
where your data (excluding headers) are in range A4:Z100. I supposed that Array is named range that refers to, in my example, A3:Z3.
您的数据（不包括标题）在A4：Z100范围内。我认为Array是命名范围，在我的例子中是指A3：Z3。
#1
1
You can use something like this:
你可以使用这样的东西：
=SUM(INDEX(A4:Z100,0,MATCH("SVYM Total" & "Jun-14",Array,0)))
where your data (excluding headers) are in range A4:Z100. I supposed that Array is named range that refers to, in my example, A3:Z3.
您的数据（不包括标题）在A4：Z100范围内。我认为Array是命名范围，在我的例子中是指A3：Z3。