Count if

PhilScratchingmyhead · Jun 27, 2006

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 · Jun 27, 2006

hi Phil

use

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

hth
regards from Brazil
Marcelo

"PhilScratchingmyhead" escreveu:

Ardus Petus · Jun 27, 2006

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

HTH

PhilScratchingmyhead · Jun 27, 2006

Many thanks worked a treat...

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

HTH
--
AP

"PhilScratchingmyhead" <[email protected]> a
Ã©crit dans le message de [email protected]...

PhilScratchingmyhead · Jun 27, 2006

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