I need help with sumif functions.

I need help using Alteryx for Sumifs. I used excel, but the system was crashing due to huge data.

I have 2 excel tabs, and I was to sumif based on some criteria. There are 2 tabs, each with customers and sales. For the sum if, I want a unique combination of customer name and customer number for all customers in both tabs, and use sumifs to extract the sales value for each customer in for Tab 1 and Tab 2.

Please see the solution I need in the sumif tab.

Thanks for your anticipated response

sumifs.xlsx

Transformation

Accepted answers

Kenda

Hey @ibrahiminui

Attached is a workflow that I believe should help. I was able to replicate the output you're looking for on the sumif tab.

New Workflow5.yxzp

All comments

estherb47

Hi @ibrahiminui

On my phone, so unable to work directly with your data. Sounds like a job for the Summarize tool. You'd group by on the customer name and number, and then add the field you want to add.

Let me know if that helps.

Cheers!

Esther

Kenda

Hey @ibrahiminui

Attached is a workflow that I believe should help. I was able to replicate the output you're looking for on the sumif tab.

New Workflow5.yxzp

ibrahiminui

This works.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703