SUMIF Dynamic Range

[M1234]

Hi,

I need to compare current year data with last year's data e.g. if it's week 27, I will have all of 2013 week 1 - 27 data, but I have data for weeks 1 - 52 for 2012 and thus I need to SUMIF the same amount of weeks according to a cell which states the current week. I have a SUMIF formula that uses the concatenation of Country¦Client¦Year¦Week and so I need it to vary depending on the current week selected. I think I need to create a dynamic range but I'm not too sure?

Any help would be much appreciated!

Thanks

[daffodil11]

Can you post a sample worksheet so we can tell how your data is arranged? (Row or Column Headers)

[M1234]

Here you go, thanks!:

[djapigo]

Hi M1234,

I'm attaching what I think is what you need...

Notice in the highlighted section that I added some extra data and the formulas (SUMIFS) to get what you need...

Also notice that I didn't use the CODE column anymore...

Hope this helps... let me know if you have any questions...

Dennis