=SUMPRODUCT((A1:A5000=3000)*(ISNUMBER(MATCH
(G1:G5000,Pgrps,0))))/COUNT(A1:A5000)
If col. A is text, use "3000" and COUNTA in the formula
HTH
Jason
Atlanta, GA
-----Original Message-----
I need to be able to work out the percentage of certain
orders placed by
certain groups.
In column A I have numbers which determines what kind of
order it is, ie
3000??????? determines a catalogue order any other kind
of number is either a
special request or service order. Column G determines
what group made the
purchase. I have a list of all the groups which I would
like the % for stored
in a named range 'Pgrps'.
I was thinkin of using sumproduct but I cant get the
syntax right. Basically
the formula should look like
Sumproduct(range("A1:A5000"="3000")*Range
("G1:G5000"=Pgrps)/Count("A1:A5000")
Can anyone help me with this?
TIA
.
|