The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sumifs in Alteryx

lalitsankhla
7 - Meteor

Hi all,

 I was wondering whether there is a way to replicate sumifs formula in Alteryx.

I have situation where in excel I have used the following formula:

SUMIFS(sum_range , criteria_range 1,criteria 1)+SUMIFS( sum_range , criteria_range 1 ,criteria 1,sum_range,criteria_range 2,criteria 2)

 

is there a way to replicate ii?

 

Thanks in advance!

1 REPLY 1
vsoni
Alteryx
Alteryx

here is a thread which should help give you what you're after: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sumif-function/td-p/570999

 

Labels
Top Solution Authors