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

[[email protected]]

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

[Harlan Grove]

[email protected] wrote...
>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.
....

Why do you believe SUMPRODUCT doesn't work with text?

=SUMPRODUCT(--({"always","best","to","test","your","assumptions"}="test"))

[John Michl]

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

[John Michl]

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