Sum values based on 3 different criteria from database (SUMIF, MATCH, etc.)

[gintonic]

Hello everyone,

I've posted this on this older thread but maybe it has low visibility. I'm having a similar problem to that user, the only difference is that I have an extra criterion (date values) to be considered. I've tried variations of the solution presented in that post, unsuccessfully.


Could you please help me out?


- There's an example spreadsheet here
- What I need is the result of what is in G7:P10
- G1:I3 has the result of Domenic's formula from the above mentioned post


Note: I don't know much about queries, but for what I've seen so far, I'm trying to avoid query-based solutions because they don't seem to be 'dynamic', i.e. I need the cells to update correctly if I change columns, rows and/or dates (especially the latter).


Thanks in advance! Greets from Lisboa.

 

[t0azt]

Try this in I8:

=SUMIFS(INDEX($C$2:$E$17,0,MATCH($H8,$C$1:$E$1,0)),$B$2:$B$17,$G8,$A$2:$A$17,">="&I$7,$A$2:$A$17,"<"&J$7)

You will have to add a date on Q7 or it will return all zeros for july.

 

[gintonic]

Try this in I8:

=SUMIFS(INDEX($C$2:$E$17,0,MATCH($H8,$C$1:$E$1,0)),$B$2:$B$17,$G8,$A$2:$A$17,">="&I$7,$A$2:$A$17,"<"&J$7)

You will have to add a date on Q7 or it will return all zeros for july.

Fantastic, thank you very much! Kudos to you.