Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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