Countif with mutiple criteria including text
 

Hello all

Need help

Trying to use the sumproduct function to count multiple criteria where one
column has text

Example:

Col. A Col. B
6 Yes, Hot, In
8 No, Cold, Out
6 No, Hot, Out
8 No, Cold, In

I'm trying to count col. A if 8 is In

Thanks for any sugestions!

Countif with mutiple criteria including text
 

try
=sumproduct(--(a2:a22=8),--(right(b2:b22,2)="in)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BBOLD" wrote in message
...
Hello all

Need help

Trying to use the sumproduct function to count multiple criteria where one
column has text

Example:

Col. A Col. B
6 Yes, Hot, In
8 No, Cold, Out
6 No, Hot, Out
8 No, Cold, In

I'm trying to count col. A if 8 is In

Thanks for any sugestions!

Countif with mutiple criteria including text
 

.... or preferably with an extra " and an extra closing parenthesis? :-)
--
David Biddulph

"Don Guillett" wrote in message
...
try
=sumproduct(--(a2:a22=8),--(right(b2:b22,2)="in)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BBOLD" wrote in message
...
Hello all

Need help

Trying to use the sumproduct function to count multiple criteria where
one
column has text

Example:

Col. A Col. B
6 Yes, Hot, In
8 No, Cold, Out
6 No, Hot, Out
8 No, Cold, In

I'm trying to count col. A if 8 is In

Thanks for any sugestions!

Countif with mutiple criteria including text
 

Might be a bit better


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
... or preferably with an extra " and an extra closing parenthesis? :-)
--
David Biddulph

"Don Guillett" wrote in message
...
try
=sumproduct(--(a2:a22=8),--(right(b2:b22,2)="in)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BBOLD" wrote in message
...
Hello all

Need help

Trying to use the sumproduct function to count multiple criteria where
one
column has text

Example:

Col. A Col. B
6 Yes, Hot, In
8 No, Cold, Out
6 No, Hot, Out
8 No, Cold, In

I'm trying to count col. A if 8 is In

Thanks for any sugestions!