D
DP7
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
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