I Have a list in a column that has a lot of tank numbers on a ship
listed as the following:

1-1-2-V
1-1-3-V
1-1-2-F
1-1-2-F
1-1-2-J
1-1-2-F

In another column, I have a list to identify whether the tank has been
opened noted with a date if it has and blank if it hasn't. I'm trying
to count the amount of V tanks that have been opened, J tanks that have
been opened and so on. I need an if, ifcount, or vlookup formula that
can do this. Any assistance would be greatly appreciated.