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...