I'm attempting to write a formula that will count instances of certain
criteria in different columns. The results have to be dependent on
whether -both- columns contain certain data. For instance, Colunm A
must -contain- 5 Days (have to search for this since there is other
data in the cells in addition to this) and column D must contain
"TXACTN1" *or* "TXGDVW1" *or* "TXWNNE1". Based on the sample below, the
result should be 2.

...Column A... | ...Column B...
5 Days : 621 | Area TXACTN1
5 Days : 050 | Area TXBLOM1
Past Due : 621 | Area TXACTN1
Past Due : 012 | Area TXWNNE1
5 Days : 007 | Area TXGDVW1

Below is what I have tried, but the totals aren't coming up right.
Obviously, I don't have my formula correct, so could someone please
point out my mistake?

=(SUMPRODUCT(--(ISNUMBER(SEARCH("5 Days",'# DSL REPORT
TX.xls'!$A$1:$A$100)))))*SUMPRODUCT(--(ISNUMBER(SEARCH("TXGDVW1",'# DSL
REPORT
TX.xls'!$D$1:$D$100)))))*(SUMPRODUCT(--(ISNUMBER(SEARCH("TXACTN1",'#
DSL REPORT TX.xls'!$D$1:$D$100)))))
*(SUMPRODUCT(--(ISNUMBER(SEARCH("TXWNNE1",'# DSL REPORT
TX.xls'!$D$1:$D$100)))))*(SUMPRODUCT(--(ISNUMBER(SEARCH("GRID
TXWNNE1",'# DSL REPORT TX.xls'!$D$1:$D$100)))))[/b]


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=514908

telewats,

don't multiply the SUMPRODUCT's. Use one SUMPRODUCT and each --ISNUMBER
is an argument.

HTH
Kostis Vezerides