I'm getting a result of (0) for everything

"Barb Reinhardt" wrote:

Let's say you have the following:

ITEM #: A2:A5
Stock location: B2:B5
Quantity: C2:C5

G2: 101398
G3: 101598

H1 = 1
I1 = 2

H2: =SUMPRODUCT(--($A$2:$A$5=$G2),--($B$2:$B$5=H$1),($C$2:$C$5))
Copy to H3, I2 and I3.

Is that what you want?

"Johnny" wrote:

worksheet: 1

I have a list of ITEM#'s in column (A) and the coresponding STOCK LOCATION
column (B). The QUANTITY of each item is in column (C). The ITEMS are sorted
by STOCK LOCATION.

(A) (B) (C)
101398 1 120
101538 1 500
101398 2 50
101538 2 100

worksheet: 2

I want to do VLOOKUP of the ITEM#s(in columns A & C) to get the QUANITY
levels(in columns B & D), but I want to the formula in column (B) to only
look for the items the match the STOCK LOCATION the is in cell ($A$1). And
for column (D)'s formula to match cell ($C$1).

(A) (B) | (C) (D)
1 | 2
ITEM QTY level | ITEM QTY level
101398 120 | 101398 50
101538 500 | 101538 100