Lookup Across Multiple Lists

  • Thread starter Thread starter Christine Flott
  • Start date Start date
C

Christine Flott

PO Number Quantity PO Number Quantity PO Number Quantity
-------------------------------------------------------------
PO2244 400 PO2244 900
PO2244 700 PO2263 600 PO2263 700
PO2263 100 PO2306 300

Hello all,

I have three lists, see above. They contain similar information and
all have the same header "PO Number" and "Quantity." Is there any way,
with a formula, that I could find totals for each "PO Number."

I am familiar with Excel's lookup functions but can't seem to make
them fit this problem. I'd like to be able to see that PO2244 has a
total quantity of 2000. And PO2263 has a total quantity of 1400. And
so on. This list will grow so doing it manually is a problem.

I'd like to avoid VBA but maybe I won't be able to do so...

Many thanks to you!

Christine
 
=sumif(A:A,"PO2244",B:B)+Sumif(C:C,"PO2244",D:D)+Sumif(E:E,"PO2244",F:F)

You can replace "PO2244" with a cell reference for a cell that contains the
PO.
 
Tom,

This is very helpful, I appreciate your help on this (and other issues
I've resolved by using this list as a reference in the past as well!)

Christine
 
Back
Top