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