Count If Formula

[beb1227]

I need a little assistance on a fomula.



I have a tracking sheet that tracks steps in a process...by Column...

So Column C is the first step...D is the second. E is third and so on and so on.......No cell in Column D or E will ever get completed until the previous Cell..completed. and it is always a date.

I want a fomula that will count all of the Blank Cells in a column, but I only want it to count them if the Cell to the left has a Date in it.

This will tell me how many items in this piece of the process yet need to be completed.

I am able to get the count if....but the way I have it it counts all blanks in the column......

any help is appreciated.

Thanks