Thread: Count If Formula
View Single Post
 
Old 06-15-2011, 11:35 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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
File Type: xlsx Counting Blank Formula.xlsx (10.7 KB, 12 views)
Reply With Quote