=sumproduct(--(a1:a1000=1)*(b2:b1000="a"))

hth
regards from Brazil
Marcelo

"external" escreveu:


5060

i want to count that : A=1 and B="a" .
thanks


+-------------------------------------------------------------------+
|Filename: f.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=5060 |
+-------------------------------------------------------------------+

--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323