Sum Offset when cell value of first number found with formula

[erniepoe]

Hi All,

I have a sum offset formula that is not working for me and am hoping somebody can offer assistance. First, i find out the location of the cell value i want to find using the cell address CSE formula

I then use the sum offset formula, and when I the actual cell value in the formula, it works great, but when I use the cell where the cell value is found, no dice.

Any ideas on how I can make this work? Thanks so much.

 

[Fluff]

Are those actual dates formatted to show mmm yyyy or just text?

 

[erniepoe]

Just general text.

 

[Fluff]

Ok, how about

=FILTER(FILTER(C10:N100,A10:A100=C2),COLUMN(C9:N9)<=MATCH(C4,C9:N9,0))

 

[erniepoe]

you are a genius, Fluff. Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.