Lookup that returns vector(array)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BOB77 - 25 Mar 2008 08:36 GMT

I have on eproblem. I have a table that contains two columns. One is type of
product(I have 6 different products)and another is quality characteristic for
those products. I need some function that can look at the first column and
returns vector with the values just for one type of product. If that is
possible I would then use that vector to put in countif function in order to
get percentages of different product ranges for that characteristic.

Signature

You`re going to rip just what you`ve saw

Reply to this Message

Bob Phillips - 25 Mar 2008 09:27 GMT

Something like

=SUMIF(A2:A20,5490,D2:D20)/SUM(D2:D20)

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have on eproblem. I have a table that contains two columns. One is type
>of
[quoted text clipped - 5 lines]
> to
> get percentages of different product ranges for that characteristic.

Reply to this Message

BOB77 - 25 Mar 2008 16:53 GMT

I tried sumif and I get one value. I only did first part of the
equation(SUMIF(A2:A20,5490,D2:D20). Excel summed the corresponding values of
desired items from first column which is good step, because desired values
were recognized. But I don‚t want to sum them I want to get vector vector
with all values that match the criteria. If you have any other idea please
reply.
You`re going to rip just what you`ve saw

> Something like
>
[quoted text clipped - 9 lines]
> > to
> > get percentages of different product ranges for that characteristic.

Reply to this Message

Bob Phillips - 25 Mar 2008 20:50 GMT

You said you were going to use it in a formula to get the percentage so I
gave it all to you in one formula.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I tried sumif and I get one value. I only did first part of the
> equation(SUMIF(A2:A20,5490,D2:D20). Excel summed the corresponding values
[quoted text clipped - 22 lines]
>> > to
>> > get percentages of different product ranges for that characteristic.

Reply to this Message