Count Blank Cells In Row if Another Row is not Blank in excel

In excel Im trying to count Items not listed

An example of how I am trying to achieve this would be:

Item Name ---------- Listed Date

Example Item 1 ----- 12/12/12

Example Item 2 -----

Item 2 has not yet been listed. so when it's all said and done i would like to see how many items are not listed.

I have tried using the following formula to no avail.

=IF(A:A <> "",COUNTBLANK(B:B))

Is there any way I can get the count of items not yet listed?


How about

=COUNTA(A:A)-COUNTA(B:B)

If column B is actually full of formulas which return a "", this won't work as COUNTA will include the cells with formulas. In which case use:

=COUNTA(A:A)-(COUNTA(B:B)-COUNTBLANK(B:B))