Is there a SUMPRODUCT-like function that I can use on text?
 

I am trying to get a count of items meeting certain criteria. The
SUMPRODUCT function is exactly what I am looking for (only takes into
account items meeting certain criteria), but I want to do it with text.
Example criteria: Joe, Model# 397, January. That is saying that Joe,
the salesman, sold a 397 in January.

I was looking at DCOUNT functions, but I wasn't sure how to set up the
criteria (we have 8 salespeople, about 50 products, and 12 months.
That's a lot of different combinations).

Any ideas?

Thanks, let me know if you need any more information...

Is there a SUMPRODUCT-like function that I can use on text?
 

Is there a SUMPRODUCT-like function that I can use on text?
 

Use sumproduct...something like this...

=SUMPRODUCT(--(A2:A5="Joe"),--(B2:B5=397),C2:C5)

Here's a web-site with great info on Sumproduct:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

- John
www.JohnMichl.com