Multiple criteria for countif()

T

theillknight

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

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))
 
Top