Count if
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
|