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'!P27:P52="Alcohol Leek"" Concern Other Leek")*('Nov 07'!
Q27:Q52="Waiting Appt"))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1