Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Sumifs in Alteryx

lalitsankhla
7 - Meteor
‎10-25-2021 02:23 AM

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!

Labels:
Reply
0 Likes
1 REPLY 1
vsoni
Alteryx
Alteryx
‎10-25-2021 02:26 AM

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

 

Reply
0 Likes
register for inspire
designer new user guide
Labels
Top Solution Authors
View All