Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

sumifs with multirow

Crypto_raccoon
7 - Meteor

Hey! i keep making prgress with transfering excel sheets to automated alteryx solutions all thanks to alteryx community!!! thank you guys! i have another question (i am convinced it is not the last one): 

 how do i make it to altreryx using multirow formula? highlighted highlighted function criteria is from the same sheet and athers are not

10 REPLIES 10
RolandSchubert
16 - Nebula
16 - Nebula

One more try ...

2021-02-18_10-05-00.jpg

 

Two conditions are fixed (column BI and BH), use a Filter for these.

 

The remaining condition is column A from sheet 3, this is extracted from the sheet. 

 

Hopefully this is helpful.

 

 

Best,

 

Roland

Labels
Top Solution Authors