Counting rows by criteria?

Gitz

New Member
Joined
Dec 18, 2005
Messages
10
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?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Nogslaw

Well-known Member
Joined
Jul 9, 2004
Messages
904
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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,535
Messages
5,572,759
Members
412,482
Latest member
arooshrana2
Top