I believe that COUNTIFS won't appear until Excel 2007.
--
David Biddulph

"Craig Covey" <Craig wrote in message
...
First, you should change the function. Don't use COUNTIF but COUNTIFS
(multiple ranges and criterion allowed).

Here's the format:

=COUNTIFS(A2:A209,"6400",B2:B209,"Mobile")

That way, you won't need to create any concatenated column, etc.

"mike_vr" wrote:

Hi all,

I'm having a problem with the structuring of these two functions into
one.

I have two columns and I'm trying to get a count where they both agree to
certain parameters.

Column A - Numerical
6400
6401
6402
etc

Column B - Text
Blackberry
Mobile
etc

So what I'm trying to do is get a count where A = 6400 AND B=Mobile for
example.

I have this at the moment, but not getting any luck!!!

=countif(and((a2:a209)="6400",(b2:b209)="Mobile"))

Any help would be appreciated!!!

Thanks,

Mike