SUMIFS using with multiple number criteria

[cpadilla0024]

Hi,

I am having issues creating this argument. Please see attached. I need to be able to sumifs on multiple criteria in the same columns but the lookup is based on numbers. One SUMIF window would be ideal because I have pretty complicated ones.

 

[Luiz Carlos]

In this case it is better to use SUMPRODUCT.

Check the spreadsheet.

[]s

 

[bosco_yip]

In E5, copied down :

=SUMIFS(Raw!D:D,Raw!A:A,B5,Raw!B:B,C5,Raw!C:C,TRIM(MID(SUBSTITUTE("/"&D5,"/",REPT(" ",50)),{1,2}*50,50)))

Regards
Bosco

 

[cpadilla0024]

Thanks to both of you!