SUMIFS

[codytom]

I am trying to a SUMIFS in Alteryx.

For example if I have rows:

A

B

C

D

If I only want to SUM Rows A & B, how would I do this in Alteryx?

[marcusblackhill]

Hey @codytom !

If you have more information to share will be better, but if you always know which rows need to sum you can capture them using something like a filter or samples or select records tool to work separately and union back later with the rest.

If you don't know the correct position of them, you can start creating an ID with record ID to now the original position, then you organize by the rule you need to use to sum and you work separately like before.

Hope that helps!

[Qiu]

@codytom 

As @marcusblackhill  pointed out, when use Sumif, we need to specify the IF condition, which is not given as of now.

[Emil_Kos]

Hi @codytom,

Like others posted it is quite hard to help without the data itself. I have searched for you some materials on the community that might help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sumif-function/m-p/571177/highlight/tr...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-use-If-statement-with-Sumifs-in...

Probably this isn't the answer to your problem but those posts might give you some inspiration,

If you still need some help please be so kind and share with us some sample data and the desired output. 

[Tyro_abc]

Hi @codytom 

It is very difficult for me to understand your requirement. You can use IF condition in Formula tool or you can use Multi row formula tool. But if you be able to provide some more detail, then it would be helpful.

[codytom]

Hi,

For example, if I had a large dataset that had multiple rows of apples and oranges. I want to create a SUMIFS function to add all apples and orange and create a new row called fruit. 

Sorry, bear with me haha this is the best example I could think of.

What would the formula be for this?

[christine_assaad]

Hi @codytom 

Please check the below. Cheers!

[messi007]

@codytom,

Please see below:

Attached the workflow,

Hope that helps,

Regards,

[codytom]

What would the formula be if I had Fruits, Veggies, Meat, and Drinks?

[christine_assaad]

Hi @codytom 

Good question! it would be:

If [field] IN ("apples","Oranges") then "Fruit"

Elseif [field] IN ("broccoli","Carrots") then "veggies"

Elseif [field] IN ("coke","Sprite") then "Soda" else "Meat" endif.