Need a Formula please*

F

f_pamela

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
 
E

Eduardo

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

f_pamela

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.
 
E

Eduardo

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

f_pamela

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!
 

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

Top