countif multiple columns

creeves · Mar 22, 2004

Count the number of times that both Y is found in column B2:B116 and
is found in column D2

11

Max · Mar 22, 2004

One way:

=SUMPRODUCT((B2:B116="Y")*(D2

116="Z"))

Frank Kabel · Mar 22, 2004

Hi
try
=SUMPRODUCT((B2:B116="Y")*(D2

116="Z"))

JE McGimpsey · Mar 22, 2004

one way:

=SUMPRODUCT(--(B2:B116="Y"),--(D2

116="Z"))