CountIfs

[vreeckes]

I'm looking to get a count by using two selection criteria. So far I've used
this formula and have not been successful.

=COUNTIFS('Column Integration'!Z2:Z17,"2", 'Column
Integration'!T2:T1082,"Recommended")

Basically I want a count of all fields that are "Recommended" and have a
value of "2".

Thanks for any help anyone can provide.

 

[Bob Phillips]

You need the test ranges to be the same size as they are being matched off.

 

[Chip Pearson]

Try getting rid of the quotes around the 2 character.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Max]

Try this sumproduct equivalent (all in the same cell):
=SUMPRODUCT(('Column Integration'!Z2:Z1082=2)*
('Column Integration'!T2:T1082="Recommended"))

The ranges need to be of identical size. And I've also presumed that your
col Z contains real numbers, ie you meant: =2

If above helped, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik

 

[T. Valko]

Try this...

Use cells to hold your criteria.

A1 = Recommended
B1 = 2

=COUNTIFS('Column Integration'!T2:T1082,A1,'Column Integration'!Z2:Z1082,B1)