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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 09-02-2014, 11:47 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
It's my fault I'm not explaining this very well so I'll try a couple of ways.

I need a running total every time the random number in A1<.1. I need it to add 1 each time the random number is less than .1. The reset to 0 is what I'm trying to avoid. I'm looking for a way to have A2 add to itself each time the condition is met.

example
A1 .06, A2 1
recalculate A1 .4, A2 1
recalculate A1 .09, A2 2
Reply With Quote
 

« 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:55 PM.

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