CODEWITHSUNDEEP
excel
Ryan Lutz
Ryan Lutz

Reputation: 245

Excel: select value from multiple id's

So, I want to find all the id's (there could be multiple) in column orderId. This is the formula i have...

=LOOKUP(INDIRECT("A" & ROW()),Table2[orderId],Table2[quantity])

it only selects the value of the last id of said number, how would i write it to select them all and add them together?

Upvotes: 0

Views: 311

Answers (1)

tigeravatar
tigeravatar

Reputation: 26640

I think you're looking for Sumif:

=SUMIF(Table2[OrderID],A1,Table2[Quantity])

Upvotes: 3

Related Questions