Hi Chris,

Am Fri, 19 Jul 2013 12:01:40 +0100 schrieb CJoQ:

NAME FRUIT
Bill Orange
Bob Apple
Jade Apple
Gillian Apple
Gillian Orange
Bob Orange
Bill Apple
Bill Orange

try:
=COUNTIFS(A1:A10,"Bill",B1:B10,"Orange")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2