Count if

[PhilScratchingmyhead]

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

 

[Marcelo]

hi Phil

use

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

hth
regards from Brazil
Marcelo

"PhilScratchingmyhead" escreveu:

 

[Ardus Petus]

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

HTH

 

[PhilScratchingmyhead]

Many thanks worked a treat...

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

HTH
--
AP

"PhilScratchingmyhead" <[email protected]> a
écrit dans le message de (e-mail address removed)...

 

[PhilScratchingmyhead]

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