[SOLVED] How can I get sum to start from a specific date till the end with 2 other specific criteria

[shadysherif]

This is a simplified sample from my sheet

in C14 I'd like to come up with a function that can check for this month in B11 and start sum the values till the rest of the table while matching also "location" & "function" with A14 and B14

I have tried many formulas with sumifs and index but i couldn't reach to a solution
Sample attached

 

[bosco_yip]

Try,

In C14, formula copied down :

=SUM(OFFSET(J$1,MATCH(1,INDEX(($A$2:$A$8=A14)*($B$2:$B$8=B14),0),0),,,MATCH($B$11,$D$1:$J$1,0)-8))

Regards
Bosco

 

[Ron Coderre]

Using your posted workbook.....
Try this regular formula, copied down:

C14: =SUMPRODUCT(($A$2:$A$8&$B$2:$B$8=A14&B14)*($D$1:$J$1>=$B$11),$D$2:$J$8)

Is that something you can work with?

 

[shadysherif]

Try,

In C14, formula copied down :

=SUM(OFFSET(J$1,MATCH(1,INDEX(($A$2:$A$8=A14)*($B$2:$B$8=B14),0),0),,,MATCH($B$11,$D$1:$J$1,0)-8))

Regards
Bosco

It's working, I'm not fully aware of the offset function, Thank you so much.

 

[shadysherif]

Using your posted workbook.....
Try this regular formula, copied down:

C14: =SUMPRODUCT(($A$2:$A$8&$B$2:$B$8=A14&B14)*($D$1:$J$1>=$B$11),$D$2:$J$8)

Is that something you can work with?

Definitely yes, simple and easy to understand , thank you guys so much I spent a whole day trying to figure out this function