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

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