Dynamically create Sumif formulas

[LAF]

We need to create a SUMIF formula that will be based on the month a user selects. I'd like to have a formula that will automatically set the formula to use the correct column (H thru BO), depending on the month number they enter. Does anyone know how this can be done? Can a formula be written where the column used on the Vendor Unit Costs sheet reflects the correct monthly column. For example, the following are SUMIF ormulas for month 1 and month 2.

Please Login or Register  to view this content.

[NBVC]

Probably something like this..

=SUMIF(UsVendVuc,$BM8,INDEX('Vendor Unit Costs'!H$319:'Vendor Unit Costs'!BO$618,0,MATCH(X1,'Vendor Unit Costs'!H$318:'Vendor Unit Costs'!BO$318,0)

where X1 is an entry to match up to the first row of your data so that it can pick the right column.... assumes row 318 contains those headers.

adjust as necessary.