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))