Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct Question
Can you use sumproduct to return an answer based on what is typed in a cell?
Here is what my spreadsheet looks like. A B C D E Load# Dest. Acc. Charge Charge Total Charge 58100 Tampa Stop $50 $1000 58100 Tampa Fuel $100 $1000 58100 Tampa Tarp $50 $1000 I'm trying to pull the individual Acc.Charges based on the Load # I put in type in a cell on a different sheet. For instance if I want to know the fuel charge for load #58100 I want the formula to pull $100. Here is the formula I'm using =SUMPRODUCT((A3:A194=T15)*(C3:C194=FUEL )*D3:D194). T15 is the cell on the seperate sheet I'm typing the load # in. Thanks, TB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct Question
--Your formula is correct except that if tried from a different sheet (sheet
same as where you sepecify the load number in T15) you will need to specify the sheet references.. --Since Fuel is a text that shouldbe enclosed in double quotes =SUMPRODUCT((Sheet1!A3:A194=T15)*(Sheet1!C3:C194=" FUEL")* Sheet1!D3:D194) -- Jacob "TB@work" wrote: Can you use sumproduct to return an answer based on what is typed in a cell? Here is what my spreadsheet looks like. A B C D E Load# Dest. Acc. Charge Charge Total Charge 58100 Tampa Stop $50 $1000 58100 Tampa Fuel $100 $1000 58100 Tampa Tarp $50 $1000 I'm trying to pull the individual Acc.Charges based on the Load # I put in type in a cell on a different sheet. For instance if I want to know the fuel charge for load #58100 I want the formula to pull $100. Here is the formula I'm using =SUMPRODUCT((A3:A194=T15)*(C3:C194=FUEL )*D3:D194). T15 is the cell on the seperate sheet I'm typing the load # in. Thanks, TB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct question please | Excel Discussion (Misc queries) | |||
A SUMPRODUCT question | Excel Discussion (Misc queries) | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
sumproduct question | Excel Programming | |||
SumProduct Question | Excel Worksheet Functions |