Sumif/Index/Match/Match - Please Help!

[MJGriggs]

Please see attached file with more notes - for example of much much larger data set that is very complicated in design. The idea is to create a monthly sum - for a dynamic set of 3 months - that will sum the correctly matched column for just the dates that fall in the month/year (driven from another sheet) and product matchup for that record.
i.e for the row highlighted red; the lookup/match is to the BRIST worksheet (dynamic sheet name based on column I, for the months of Oct/Nov/Dec, sum up by month the values in Columns BY:CB based on the match of the column header to the value in Col H of the orig worksheet. Is this even possible? I've been trying various iterations of sumif/sumproduct/index/match etc... with no success. Am in a new job at a new company and this is my first project so any help is greatly appreciated.

Mod Edit:
Cross-posted here: https://www.excelguru.ca/forums/showthread.php?9458-Sumifs-Index-Match-Indirect-Combo-Formula

 

[MJGriggs]

The closest I've come is:
=SUMPRODUCT(INDEX(INDIRECT($I8&"!$BY:$CB"),MATCH(Sheet2!$K$5,INDIRECT($I8&"!$DA:$DA"),0),MATCH(Sheet2!$H8,INDIRECT($I8&"!$BY$3:$CB$3"),0)))
but it is not summing, only giving the first occurrence.

 

[Haz]

=SUMIFS(INDEX(INDIRECT($I7&"!1:1048576"),,MATCH($H7,INDIRECT($I7&"!3:3"),0)),INDEX(INDIRECT($I7&"!1:1048576"),,MATCH("Date",INDIRECT($I7&"!3:3"),0)),">="&DATE(K$3,K$4,1),INDEX(INDIRECT($I7&"!1:1048576"),,MATCH("Date",INDIRECT($I7&"!3:3"),0)),"<="&EOMONTH(DATE(K$3,K$4,1),0))

 

[AliGW]

When you post the same request on multiple forums, you are required to say so (please see the rules on this and other forums).

 

[MJGriggs]

I apologize I was not aware as this was my first post.

 

[MJGriggs]

=SUMIFS(INDEX(INDIRECT($I7&"!1:1048576"),,MATCH($H7,INDIRECT($I7&"!3:3"),0)),INDEX(INDIRECT($I7&"!1:1048576"),,MATCH("Date",INDIRECT($I7&"!3:3"),0)),">="&DATE(K$3,K$4,1),INDEX(INDIRECT($I7&"!1:1048576"),,MATCH("Date",INDIRECT($I7&"!3:3"),0)),"<="&EOMONTH(DATE(K$3,K$4,1),0))

This looks like it would work, but is resulting in all zeroes from the secondary sheet (Brist). Thank you so much.

 

[MJGriggs]

THANK YOU SO MUCH. My mistake - this does work - my year field was blank! I really appreciate this - you saved me!

 

[Haz]

Check the attached file.
It seems fine to me, do you have access to SUMIFS?

 

[MJGriggs]

Check the attached file.
It seems fine to me, do you have access to SUMIFS?

Thanks again. This is wonderful. When clicking on the Donate page, your member name does not appear.

 

[pecoflyer]

I apologize I was not aware as this was my first post.

You should read forum rules before posting