software

I have a problem I want to count with multiply parameters.
ex.
tp403 e
lp602 p
tp601 e
tp403 p

I want to count when column 1 is tp... and column 2 is e. I can count, but
i have a problem with using wildcard *.=SUMPRODUCT(--(LEFT(A1:A100,2)=quot;tpquot;),--(B1:B100=quot;equot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wcquot; gt; wrote in message
...
gt; I have a problem I want to count with multiply parameters.
gt; ex.
gt; tp403 e
gt; lp602 p
gt; tp601 e
gt; tp403 p
gt;
gt; I want to count when column 1 is tp... and column 2 is e. I can count,
but
gt; i have a problem with using wildcard *.
gt;

If you make an extra column which concatentate the two fields (maybe
with an unusual separator for safety), you can then use the COUNTIF
function on this.

tp403etp403|e
lp602plp602|p
tp601etp601|e
tp403ptp403|p=COUNTIF(C1:C4,quot;tp*|equot;) gives the value of 2--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=536900