How do you count how often a specific value occurs in single changing cell?

blackjack · #3 09-02-2014, 11:13 AM

Quote:

Originally Posted by gebobs

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum values within a single cell	shabbaranks	Excel	17	05-13-2014 06:47 PM
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 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