I would create a helper column which concatenates the two cells and then
count the concatenated strings.

Assume A2 = 6400 and B2 = Mobile.

Then in C2 =CONCATENATE(A2,B2) yields 6400Mobile

=COUNTIF(C2:C209,"6400Mobile") will get you what you want.

Dave
--
Brevity is the soul of wit.


"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