CountIfs
 

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.

CountIfs
 

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

--
__________________________________
HTH

Bob

"vreeckes" wrote in message
...
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.

CountIfs
 

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)

On Wed, 18 Feb 2009 15:13:04 -0800, vreeckes
wrote:

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.

CountIfs
 

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
---
"vreeckes" wrote:
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.

CountIfs
 

Try this...

Use cells to hold your criteria.

A1 = Recommended
B1 = 2

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


--
Biff
Microsoft Excel MVP


"vreeckes" wrote in message
...
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.