Counting data in columns

[telewats]

I'm attempting to write a formula that will count instances of certai
criteria in different columns. The results have to be dependent o
whether -both- columns contain certain data. For instance, Colunm
must -contain- >5 Days (have to search for this since there is othe
data in the cells in addition to this) and column D must contai
"TXACTN1" *or* "TXGDVW1" *or* "TXWNNE1". Based on the sample below, th
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 pleas
point out my mistake?

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

 

[vezerid]

telewats,

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

HTH
Kostis Vezerides