Replace SUMIFS with INDIRECT

I'm looking to replace this function

=SUMIFS('IW49N Download'!$I$7:$I$5012,'IW49N Download'!$A$7:$A$5012,$D12,'IW49N Download'!$C$7:$C$5012,"BNE_I")

with a function like this


=IFERROR(INDIRECT("'IW49N Download'!F"&SMALL(IF('IW49N Download'!$A$7:$A4993=Friday!$D12,ROW('IW49N Download'!$A$7:$A4993)),COUNTIF($D$11:$D12,$D12))),"")

The problem that I have is that I need a second INDIRECT argument within the function that will return a result that references both the contents of cell D12 and the contents in cell C12 which could be BNE_I or BNMWRT or BNPIPE etc.

So you're replacing a SUM with a boolean.

Okay.

I guess you cant get it to check the right range? Is that your question? I can't really tell what you need.

Or what you want the test to even be doing. You say it needs a second INDIRECT, but that's like a context-free assertion without knowing anything about the input or output are supposed to be.

What is your question?