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

Hi,

This formula will return a count where cells in column C have a date and cells in column D are blank:

__________________
Colin

RAD Excel Blog

thanks Colin

that appears to be close...but as I run this out a few columns.....it is still calculating...this runs the same sequence out to comumn N.

but it appears to me that if the first column has a date in it...it is still counting this as my main requirement to check for blanks in the cell to the right.

Do I need to add something to say that if Column to is 0> and not blank?

Hi,

Please can you attach a workbook with a small (!) data sample and explain what results you want to see?

__________________
Colin

RAD Excel Blog

Here is a sample

The row at the top is to count the blanks....and I tried to modify so the numbers should change

but if there is a date in the column...and a blank to the right...that should be counted. if there is no date in a column...and a blank to the right...it should not be counted.

Column C appears correct to me.

Attached Files

counting blank formula.xlsx (9.5 KB, 11 views)

Hi
Please find herewith a solution. The issue is because after the first formula you were creating a circular reference in the other columns. By inserting an extra column between each of your columns and putting the formula in each blank column avoids the circular reference problem.

I am sure Colin will come up with a more efficient solution.

Hope this helps.
Tony (OTPM)

Attached Files

Counting Blank Formula.xlsx (11.8 KB, 10 views)

yeah, that does work....kinda

is that just becuase the formulas are side by side...or is it the actual columns of data?

Hi
Here is a better version. It will calculate rows from row 3 to row 1000, you can chnage this to suit. The issue was the calculation was working on the same cell that contained the formula hence the circular reference.
Hope this helps.
Tony (OTPM)

Attached Files

Counting Blank Formula.xlsx (10.7 KB, 12 views)

oh dang

that made it look all but to easy

was wondering. on a larger but similar sheet. I have tracking by regions of the Country....NW, SW, E, W etc...

any suggestions on how to have this be broken down.....say Column A has the regions and I want to have do the formula above...if A = SW


This would be used to create a table to break down the # of items received by region...


Thanks

Hi
Can you post a sample of your spreadsheet and we will try and help you.
Tony (OTPM)