Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with SUMPRODUCT? | Excel Worksheet Functions | |||
Sumproduct Help | Excel Discussion (Misc queries) | |||
Sumproduct? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Help | Excel Worksheet Functions | |||
SUMPRODUCT Help | Excel Worksheet Functions |