Excel SUMIF formula replecament

Question

Hi everyone,

I have this excel formula: =SUMIFS('Sheet1'!$L$2:$L$39;'Sheet1'!$A$2:$A$39;Mapping!$E$6;'Sheet1'!$O$2:$O$39;Mapping!C7)
And I can't figure out what Alteryx tools I can use to map this formula to get the same functionality. Can you help me?

Thanks in advance

binu_acs · Answer

@szanto It would be very easy to provide a solution if you can provide the input file and expected output rather than providing the formula,

aatalai · Answer

use the filter tool and then use the summarise tool

Let me know how you get on