That formula dosen't work for my file because I only have tank numbers
in column A (8-121-2-J) and dates, blanks, & text in column P. That did
give me an idea to try the following and that works, but it's messy:

=SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P1611DATE(2004,1,1)))-SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P1611="N/A"))-SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P1611="NO"))-SUMPRODUCT((ISNUMBER(SEARCH("-J",A9:A1611)))*(P9:P1611="Yes"))


I really need something on the end of the first example to determine
the difference between a date and text.