=SUMPRODUCT((A1:A999="apples")*(B1:b999="red"))

HTH
--
AP

"PhilScratchingmyhead" a
écrit dans le message de news:
...
Hi I want to count if col a=apples and col b=red so if col a=apples and
col
b=green then it wouldn't add one to the total so I would end up with how
many
red apples I have listed down????

Many thanks ya'll
P.x