Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a Formula please*
I have two sheets on one model number, cost, on the second sheet several
models with sales prices by districts, like 50,51,55,58,61, now i need to find the price of disctrict 50 for this model and then the price for the disctric 51 etc, how can i do this formula? i have a lot of models and need to find the prices for each district. example on sheet one model number cost 50 51 55 58 61 123 $10.61 ? ? ? ? ? second sheet model price disct 1234 609 50 1234 609 51 1234 609 55 1234 609 58 123 609 50 123 609 51 123 609 58 123 649 60 1854 649 55 1854 649 60 18547 649 55 Thank you for yout help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a Formula please*
Hi,
I assume that model number is in Cell A2 and district 50 is in cell C1 and the list is in sheet 2 in cell C2 =sumproduct(--(C1=sheet2!C1:C1000),--(A2=sheet2!A1:A1000),sheet2!B1:B1000) if you are using 2007 enter =sumproduct(--(C1=sheet2!C:C),--(A2=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: I have two sheets on one model number, cost, on the second sheet several models with sales prices by districts, like 50,51,55,58,61, now i need to find the price of disctrict 50 for this model and then the price for the disctric 51 etc, how can i do this formula? i have a lot of models and need to find the prices for each district. example on sheet one model number cost 50 51 55 58 61 123 $10.61 ? ? ? ? ? second sheet model price disct 1234 609 50 1234 609 51 1234 609 55 1234 609 58 123 609 50 123 609 51 123 609 58 123 649 60 1854 649 55 1854 649 60 18547 649 55 Thank you for yout help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a Formula please*
Unfurtunately didn't do anything with this formula, below i add how i have
and in which cells, maybe this can help me to explained better, thank you in advance for your help. "Eduardo" wrote: Hi, I assume that model number is in Cell A2 and district 50 is in cell C1 and the list is in sheet 2 in cell C2 =sumproduct(--(C1=sheet2!C1:C1000),--(A2=sheet2!A1:A1000),sheet2!B1:B1000) if you are using 2007 enter =sumproduct(--(C1=sheet2!C:C),--(A2=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: I have two sheets on one model number, cost, on the second sheet several models with sales prices by districts, like 50,51,55,58,61, now i need to find the price of disctrict 50 for this model and then the price for the disctric 51 etc, how can i do this formula? i have a lot of models and need to find the prices for each district. example on sheet one A1 B1 C1 D1 E1 F1 G1 model number cost 50 51 55 58 61 123 $10.61 ? ? ? ? ? second sheet A1 B1 C1 model price disct 1234 609 50 1234 609 51 1234 609 55 1234 609 58 123 609 50 123 609 51 123 609 58 123 649 60 1854 649 55 1854 649 60 18547 649 55 Thank you for yout help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a Formula please*
Hi,
=sumproduct(--(C1=sheet2!C1:C1000),--(A1=sheet2!A1:A1000),sheet2!B1:B1000) is the name of your 2nd sheet "Sheet2" if not replace in the formula If you are using 2007 =sumproduct(--(C1=sheet2!C:C),--(A1=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: Unfurtunately didn't do anything with this formula, below i add how i have and in which cells, maybe this can help me to explained better, thank you in advance for your help. "Eduardo" wrote: Hi, I assume that model number is in Cell A2 and district 50 is in cell C1 and the list is in sheet 2 in cell C2 =sumproduct(--(C1=sheet2!C1:C1000),--(A2=sheet2!A1:A1000),sheet2!B1:B1000) if you are using 2007 enter =sumproduct(--(C1=sheet2!C:C),--(A2=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: I have two sheets on one model number, cost, on the second sheet several models with sales prices by districts, like 50,51,55,58,61, now i need to find the price of disctrict 50 for this model and then the price for the disctric 51 etc, how can i do this formula? i have a lot of models and need to find the prices for each district. example on sheet one A1 B1 C1 D1 E1 F1 G1 model number cost 50 51 55 58 61 123 $10.61 ? ? ? ? ? second sheet A1 B1 C1 model price disct 1234 609 50 1234 609 51 1234 609 55 1234 609 58 123 609 50 123 609 51 123 609 58 123 649 60 1854 649 55 1854 649 60 18547 649 55 Thank you for yout help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a Formula please*
i got the problem, i do not know why if is not in "TEXT" does not run the
formula. There is any way to change that? Thank you, but the name wasn't the problem, You are the best! "Eduardo" wrote: Hi, =sumproduct(--(C1=sheet2!C1:C1000),--(A1=sheet2!A1:A1000),sheet2!B1:B1000) is the name of your 2nd sheet "Sheet2" if not replace in the formula If you are using 2007 =sumproduct(--(C1=sheet2!C:C),--(A1=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: Unfurtunately didn't do anything with this formula, below i add how i have and in which cells, maybe this can help me to explained better, thank you in advance for your help. "Eduardo" wrote: Hi, I assume that model number is in Cell A2 and district 50 is in cell C1 and the list is in sheet 2 in cell C2 =sumproduct(--(C1=sheet2!C1:C1000),--(A2=sheet2!A1:A1000),sheet2!B1:B1000) if you are using 2007 enter =sumproduct(--(C1=sheet2!C:C),--(A2=sheet2!A:A),sheet2!B:B) "f_pamela" wrote: I have two sheets on one model number, cost, on the second sheet several models with sales prices by districts, like 50,51,55,58,61, now i need to find the price of disctrict 50 for this model and then the price for the disctric 51 etc, how can i do this formula? i have a lot of models and need to find the prices for each district. example on sheet one A1 B1 C1 D1 E1 F1 G1 model number cost 50 51 55 58 61 123 $10.61 ? ? ? ? ? second sheet A1 B1 C1 model price disct 1234 609 50 1234 609 51 1234 609 55 1234 609 58 123 609 50 123 609 51 123 609 58 123 649 60 1854 649 55 1854 649 60 18547 649 55 Thank you for yout help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|