Sumifs with $ in alteryx

[Metadata21]

Hi 

I want to recreate this formula in Alteryx - iI know it is something to do with summarize tool but not sure how to go about it

[IraWatt]

Hey @Metadata21,

Could you provide a sample excel sheet? The logic for SUMIFS in Alteryx is just a filter tool followed by a summarize tool using the sum function:

The filter tool is used to select the 'cells' that meet the criteria and the summarise does the SUM.

Any questions or issues please ask :)
HTH!
Ira

[Metadata21]

@IraWatt please see attached 

[IraWatt · Accepted solution]

Hey @Metadata21,

Ah okay what SUMIF is doining here is for each Cd_ BSEnt its suming Sum_Cd_ InvAmt. This is the same as grouping by and summing in Alteryx:

Any questions or issues please ask :)
HTH!
Ira

[Metadata21]

@IraWatt you are a star! exactly what i wanted! thank you!!!

[andreas22]

@IraWatt

Thank you for your help. That worked for me!

[IraWatt]

No worries glad it worked for you ! :)