Sumproduct formula problem

[chedd via OfficeKB.com]

I am trying to try and find the sumproduct of two names in a column P to
who are still waiting appt.showing in column Q The formal i am using is only
giving a 0 fig. I do know that there are 25 waiting. Can you tell me to
where i going wrong or using the formula.

Again thanks for your assistance i think this is great web sight as i have
used it many times.


=SUMPRODUCT(('Nov 07'!P2752="Alcohol Leek"" Concern Other Leek")*('Nov 07'!
Q27:Q52="Waiting Appt"))

 

[Peo Sjoblom]

What is this supposed to mean

"Alcohol Leek"" Concern Other Leek"

do you actually have quotations within the text string itself in P2752? If
so you need to use

=SUMPRODUCT(('Nov 07'!P2752="Alcohol Leek"""" Concern Other Leek")*('Nov
07'!Q27:Q52="Waiting Appt"))

or

=SUMPRODUCT(--('Nov 07'!P2752="Alcohol Leek"""" Concern Other
Leek"),--('Nov 07'!Q27:Q52="Waiting Appt"))


if you are looking for either Alcohol Leek OR Concern Other Leek


=SUMPRODUCT(('Nov 07'!P2752={"Alcohol Leek","Concern Other Leek"})*('Nov
07'!Q27:Q52="Waiting Appt"))

or

=SUMPRODUCT(--('Nov 07'!P2752="Alcohol Leek")+('Nov 07'!P2752="Concern
Other Leek"),--('Nov 07'!Q27:Q52="Waiting Appt"))

or

=SUMPRODUCT(--(('Nov 07'!P2752="Alcohol Leek")+('Nov 07'!P2752="Concern
Other Leek")>0),--('Nov 07'!Q27:Q52="Waiting Appt"))


--


Regards,


Peo Sjoblom

 

[Bob Phillips]

Are the values in P really

Alcohol Leek" Concern Other Leek

seems odd data.

--
HTH

Bob

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