count function

[kurt]

Hi all

How to count in Excel with 2 or more arguments

Somthing like this

=Countif (a2:a200 = "A" and B2:B200="B")

Please Advise

regards

Kurt

 

[Bernard Liengme]

=SUMPRODUCT(--(A2:A200 = "A"),--(B2:B200="B"))
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes