Counting data in columns

[telewats]

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]

[vezerid]

telewats,

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

HTH
Kostis Vezerides