sumif with offset match

[sh1pley]

Hi

I have a summary page with monthly date column headings. At the moment I have all the months for 6 years going across the sheet. Below these headings I am doing a simple sumif formula that looks at the relevent column in another sheet.

What I need to do is only show 12 months based on a drop down box and have the sumif formula look at the relevent column.

I believe I can do this with some sort of Sumif(offset(match formula but I cant get this to work?

 

[T. Valko]

Hi

I have a summary page with monthly date column headings. At the moment I have all the months for 6 years going across the sheet. Below these headings I am doing a simple sumif formula that looks at the relevent column in another sheet.

What I need to do is only show 12 months based on a drop down box and have the sumif formula look at the relevent column.

I believe I can do this with some sort of Sumif(offset(match formula but I cant get this to work?

Try something like this...

=SUMIF(A2:A100,"X",INDEX(B2:Z100,,MATCH(A1,B1:Z1,0)))

Where A1 = the variable column header to be matched.