Thanks Allllen, that's worked out nicely. Just by the way, what is the
significance of th (--( before the ranges?

Cheers,

Mike

"Allllen" wrote:

The standard way to do that kind of thing is
=SUMPRODUCT(--(A1:A5=6401),--(B1:B5="Mobile"))

more info here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Allllen


"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

http://www.xldynamic.com/source/xld....T.html#explain
--
Allllen


"mike_vr" wrote:

Thanks Allllen, that's worked out nicely. Just by the way, what is the
significance of th (--( before the ranges?

Cheers,

Mike

"Allllen" wrote:

The standard way to do that kind of thing is
=SUMPRODUCT(--(A1:A5=6401),--(B1:B5="Mobile"))

more info here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Allllen


"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