Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 06-15-2011, 10:55 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
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
File Type: xlsx Counting Blank Formula.xlsx (11.8 KB, 12 views)
Reply With Quote
 

Thread Tools
Display Modes


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 03:02 AM.


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