Not sure that I have got it, but I'll try this

=SUMPRODUCT((ISNUMBER(SEARCH("-J",P9:P16)))+(P9:P16DATE(2004,1,1)))-SUMPROD
UCT((ISNUMBER(SEARCH("-J",P9:P16)))*(P9:P16DATE(2004,1,1)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lankchevy" wrote in message
oups.com...
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.