I have one column that has my tank numbers and my other column has the
dates entered for when tanks are opened. This formula works fine
counting the matching tanks with the amount of cells that have a date
entered (cells that are not blank):

=SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(AA9:AA1611<""))

What I need for my other column is a sumproduct formula that can
determine the difference between a date and a text. The previous
formula only will have a date or have a blank cell. This new column
will have a date or a text.
I have tried the following, but it either counts the text & date or
neither:

=SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P1611DATE(2004,1,1)))
=SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(YEAR(P9:P1611)=2005))
=SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P16111))

The problem I'm sure is with the second part.
Any help would be greatly appreciated.