Count if
 

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

Count if
 

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

Count if
 

=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

Count if
 

Many thanks worked a treat...

"Ardus Petus" wrote:

=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

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