Count If Formula
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
|