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.