Sumifs in Alteryx

[lalitsankhla]

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!

[vsoni]

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