Lookup Across Multiple Lists
 

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

Lookup Across Multiple Lists
 

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

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

--
Regards,
Tom Ogilvy

"Christine Flott" wrote in message
om...
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

Lookup Across Multiple Lists
 

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