Record Count

**kumar_viswa2003** · 03-30-2005, 12:04 PM

I have two columns one with client name and another with employee name. example:
aaa cathy
ddd sime
aaa sime
aaa cathy
ddd cathy
I want to count no of jobs done by cathy for aaa. The result should be 2
Thanks

**Domenic** · 03-30-2005, 01:00 PM

Try...

=SUMPRODUCT(--(A1:A5="aaa"),--(B1:B5="cathy"))

OR

=SUMPRODUCT(--(A1:A5=C1),--(B1:B5=D1))

...where C1 contains your first criterion, and D1 your second.

Hope this helps!

**kumar_viswa2003** · 03-31-2005, 10:09 PM

Thanks Domenic...... it works fine........

Can u also let me know what is the role of "--" in that formula... and it will be greatful if you could let me know in which other cases we can use this.