Multiple criteria for countif()

[theillknight]

Is there some method to use countif for multiple criteria instead of
adding several single-criteria countif's together?

 

[Earl Kiosterud]

Knight,

We generally use SUMPRODUCT to count rows meeting conditions.

=SUMPRODUCT((A2:A7=5)*(B2:B7="Good"))
=SUMPRODUCT((A2:A7=5)*(B2:B7="Good")*(C2:C7=1))

 

[Frank Kabel]

Hi
use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html