I want to add a SUMIFS formula to the 'Main' sheet but using a VLOOKUP to define the reference for the SUMRANGE column on the 'Data' sheet. The value for the lookup is controlled by the entry in cell H1 on the 'Main' tab, so if H1 = 1, the SUMRANGE is column A on the Data tab and likewise if H1 = 6 then the SUMRANGE is column F on the Data tab and so on. So I'm trying to say something like:
But I can't figure out the correct syntax. Ideally the SUMRANGE should be effectively row2 to the last row of data on the Data tab.Please Login or Register to view this content.
Many thanks
Bookmarks