Counting rows by criteria?

[Gitz]

Hey.

I'm a little noob at this but how can I make a counter that counts how many rows in a table that meets my 2 or 3 criteria. the criteria will be put in 3 different cells over the table?

 

[Nogslaw]

Does it need to meet all 3 criteria, or count it if it meets any of the three criteria? And what are the 3 criteria?

 

[barry houdini]

Welcome to the board

Sounds like you may want SUMPRODUCT, e.g.

=SUMPRODUCT(--(A1:A100="x"),--(C1:C100="y"))

counts rows within the range where both criteria are met.

 

[Gitz]

Thx alot.