Sumifs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi I am relatively new to Alteryx and am completely stuck on how to do sumifs in alteryx.
I am trying to get the formula to be Sumifs=(C:C,A:A, "A",B:B, "Property")
Please see the attached dummy data. I am honestly so lost, any help would be appreciated!
Solved! Go to Solution.
- Labels:
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The equivalent in Alteryx would be to use the Summarize tool, if you want to get the overall total for where Name = A, and Type = Property, add the Summarize tool, and use Group By Name, Group By Type and Sum Total. That will give you the totals of all names and types. Then Filter where the Name = A and the Type = Property.
This link might help too.. https://www.alteryx.com/alteryx-excel
Hope that helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @alia10 --
You will want to use the Summarize tool. You will Group by the Name and type and then Sum by Total.
Thanks,
Seth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for you help! That was just part 1 of what my manager wants. I have a follow up problem, our real data includes all 50 states, and I need to figure out how to sum the data for each individual state for each entity for property.
Not sure if that makes sense. Please see the updated data.
Would i be making a formula for each state per entity?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Same concept. Use another summarize tool and group by state and sum by your balance.
thanks,
Seth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is this what you're looking for?
I would use a filter tool to identify all records that are for property. Then, use a transpose tool to get all values in one column. From there, you can use a summarize tool with a group by on State and sum on value to get the total per state.
Let me know if that works for you! Workflow attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sort of, but i need to have it broken out by entity. So it should be broken out by A, B, C
Also I the workflow you shared, does not want to download for me