Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 06-15-2011, 11:35 AM
OTPM OTPM is offline Count If Formula Windows 7 32bit Count If Formula 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, 14 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word count question Wuffybrother Word 3 03-22-2019 03:40 AM
Count If Formula Count in Excel zanat0s Excel 3 06-09-2011 10:53 AM
Don't count hidden slides Lu_Argentina PowerPoint 0 10-12-2010 02:12 PM
How to Count from Different Cells? Shahzad Excel 3 06-26-2010 01:06 AM
Don't count 0 in a chart Rmaisone Excel 0 08-21-2006 12:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft