Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How do you count how often a specific value occurs in single changing cell? How do you count how often a specific value occurs in single changing cell?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2014, 11:06 AM
gebobs gebobs is offline How do you count how often a specific value occurs in single changing cell? Windows 7 64bit How do you count how often a specific value occurs in single changing cell? Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
The equation in A2 should be:

=countif(a1,"<.1")



I've tested it and it seems to work fine for me. Is your recalculation set to automatic?
Reply With Quote
  #2  
Old 09-02-2014, 11:13 AM
blackjack blackjack is offline How do you count how often a specific value occurs in single changing cell? Windows 7 64bit How do you count how often a specific value occurs in single changing cell? Office 2007
Novice
How do you count how often a specific value occurs in single changing cell? 		 
Join Date: Sep 2014
Posts: 13
blackjack is on a distinguished road
Default
Quote:
Originally Posted by gebobs View Post
The equation in A2 should be:

=countif(a1,"<.1")

I've tested it and it seems to work fine for me. Is your recalculation set to automatic?
Thank you for trying but it doesn't work. I need it to count each time the condition is met, the formula resets back to zero after the field changes.

Either this is impossible or it's something simple. No idea.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you count how often a specific value occurs in single changing cell? Sum values within a single cell shabbaranks Excel 17 05-13-2014 06:47 PM
How do you count how often a specific value occurs in single changing cell? count how many tims a certain value occurs lucnijs Excel 6 03-26-2012 09:29 AM
How to count year lapse (rounded off) based on specific date KIM SOLIS Excel 1 11-01-2011 10:50 AM
How do you count how often a specific value occurs in single changing cell? How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
changing word count hamster Word 3 06-03-2010 01:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 AM.

Contact Us - Privacy Statement - Top

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