Many thanks worked perfectly - good luck for the football..


"Marcelo" wrote:

hi Phil

use

=sumproduct(--(a2:a100="Apple")--(b2:b100="red))

hth
regards from Brazil
Marcelo

"PhilScratchingmyhead" escreveu:

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