Sumifs with nested Index Match not pickup values

[Brot Togs]

I am trying to use an index match to have a dynamic sumif, formula below. For whatever reason I can only pick up data that is in rows 12,000 or above. My formula does not have any row range limits so i am wondering if there is a limit of variables for criteria 3? Or is it something to do with the index match?


=SUMIFS(INDEX(CDW!$AX:$BN,0,MATCH($B$3&"UNITS",CDW!$AX$1:$BN$1,0)),CDW!$BO:$BO,$B20,CDW!$AY:$AY,DE$2,CDW!$AX:$AX,DE$1)

 

[Fluff]

Hi & welcome to MrExcel.
Are you sure that there is data below row 12,000 that matches all 3 criteria?

 

[Brot Togs]

Hi & welcome to MrExcel.
Are you sure that there is data below row 12,000 that matches all 3 criteria?

Yes because if I move the data up above 12000 its pulls perfectly fine.

 

[Brot Togs]

Hi & welcome to MrExcel.
Are you sure that there is data below row 12,000 that matches all 3 criteria?

Example if look at 2019-2022 and 2019 is not pulling because it is below 12000 but if I flip that 2022 does not pull

 

[Fluff]

In that case without access to your data I'm not sure what to suggest, as that formula should work.

 

[Brot Togs]

In that case without access to your data I'm not sure what to suggest, as that formula should work.

Shoot its confidential so I cant share it but thank you for taking a look

 

[Fluff]

You're welcome, sorry I couldn't have been more help.