SUMIF in ALteryx

[igorfv]

Hi,

How do SUMIF in Alteryx for the table below? Give me an example, please.

Thanks!

Igor Valle

[Luke_C]

Can you provide the xlsx instead of a screenshot? What have you tried in Alteryx?

Here's an interactive lesson on summarizing data https://community.alteryx.com/t5/Interactive-Lessons/Summarizing-Data/ta-p/424417

[IraWatt]

Hey @igorfv,

I agree with @Luke_C, if you could give some data along with your formula that would be excellent. SUMIF also seems to be quite a common thread on the community, have you checked out: Solved: Sumifs - Alteryx Community,Solved: SUMIFS - Alteryx Community,Solved: SUMIFS Formula - Alteryx Community ?

[Qiu]

@igorfv 
We can use a Batch Macro to do this.

And there are some accepted solutiosn if you want to check more.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SUMIFS/td-p/557099

[igorfv]

Hi Qiu and all,

Worked very well.

Thank you for your help.

Igor Valle