View Single Post
 
Old 06-15-2011, 05:40 AM
beb1227 beb1227 is offline Windows XP Office 2007
Novice
 
Join Date: May 2011
Posts: 18
beb1227 is on a distinguished road
Default 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
Reply With Quote