Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Vlookup with Sumif

MoeShow
7 - Meteor

Is it possible to do a sumif vlookup? The data I'm doing the vlookup against has multiple of the same PO numbers and I need to sumif the total in my column. For example, PO 7878 has a 20 dollar amount and 30 dollar amount on two different lines and I need the data to pull in both totals to give me that 50 bucks. 

1 REPLY 1
MoeShow
7 - Meteor

Figured it out. Nvm.