Dynamic sumif ranges based on Hlookup criteria

Hello,

how do you populate the Source Data sheet? Do you insert a new column every month?
In the Summary sheet, K is listed twice. What would be the expected result?

Originally Posted by teylyn

Hello,

how do you populate the Source Data sheet? Do you insert a new column every month?
In the Summary sheet, K is listed twice. What would be the expected result?

Thanks for the response, actually the letters listed down the colums is not a colums reference, that could be a color, a reference # or whatever. That was a bad choice of reference criteria on my part, sorry for the confusion. I actually just figured it out. I actually used

SUMIF('Act CAE'!$B$37:$B$800,Summary!$D10,OFFSET('Act CAE'!$K$37,,HLOOKUP(J$2,'Act CAE'!$K$34:$IV$36,3,FALSE)):OFFSET('Act CAE'!K$800,,HLOOKUP(J$2,'Act CAE'!$K$34:$IV$36,3,FALSE)))

The "criteria range" is fixed, and for the dynamic sum_range I used a reference cell offset by the number of columns a hlookup formula returned.

So this one is solved. But non the less, thank you for taking the time!

Cheers


P.S. Mod, do I need to "mark" this as solved? Delete it? Thanks for getting me acquainted to proper forum etiquette