I have a column that I would like to SUM. The position of the column will be variant b/c I have a vb program that is generating the excel file and writing the columns based on other critera. Therefore b/c I do not know where the column will end up, I need to find the column first and then try to SUM it. I am trying the following but it is not working. I get #VALUE. Here is my current formula. I am finding the column using match and then getting its address. I then try to do SUM.
=SUM((MID(ADDRESS(1,MATCH("mycol*",A1:CZ1,0)),2,2)&2)MID(ADDRESS(1,MATCH("mycol*",A1:CZ1,0)),2,2)&100000))
If I were to just do =MID(ADDRESS(1,MATCH("mycol*",A1:CZ1,0)),2,2)&2 THEN it would return BZ2.
and =MID(ADDRESS(1,MATCH("mycol*",A1:CZ1,0)),2,2)&100000 is working and returns BZ100000
I am trying to combine them using SUM.
I want the forumla to try and work as follows SUM(BZ2:BZ100000)
Bookmarks