SUMPRODUCT I Think!!

G

Guest

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
 
B

Bob Umlas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel Countifs/Sumproduct with mutil Or statement 3
Variable Sumproduct Range 6
Sumproduct Help! 2
SUMPRODUCT Help 14
SUMPRODUCT 3
I am in search of formula 3
SUMPRODUCT and Dates 2

Top