Hi,



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

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, 13 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, 12 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, 14 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