SUMPRODUCT I Think!!
 

I have no idea why my sumproduct formula is not working. I am trying to have
it match 2 seprate valuse a then return the coressponding price from a price
list. the formula is
=SUMPRODUCT((A$1:A$5=E2)*(B$1:B$5=F2),G$2:G$7). See a saple of data below
g is the prices of goods.


A B E F G
RED 3 7
blue 6 36
Green 9 39
Yellow 3 5
Purple 2 6

SUMPRODUCT I Think!!
 

A1:A5 and B1:B5 are 5 rows long; G2:G7 is 6 rows long. They must all be the
same size.
Also, in your example, E2 & F2 are empty (but you knew that!)
Bob Umlas
Excel MVP

"DP7" wrote in message
...
I have no idea why my sumproduct formula is not working. I am trying to
have
it match 2 seprate valuse a then return the coressponding price from a
price
list. the formula is
=SUMPRODUCT((A$1:A$5=E2)*(B$1:B$5=F2),G$2:G$7). See a saple of data below
g is the prices of goods.


A B E F G
RED 3 7
blue 6 36
Green 9 39
Yellow 3 5
Purple 2 6