Lookup that returns vector(array)

  • Thread starter Thread starter BOB77
  • Start date Start date
B

BOB77

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.
 
Something like

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


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



Bob Phillips said:
Something like

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


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
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.

--
---
HTH

Bob


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



BOB77 said:
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
Click to expand...
 
Back
Top