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

P

patryan22

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

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.
Click to expand...
....

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

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