View Single Post
 
Old 09-02-2014, 11:13 AM
blackjack blackjack is offline Windows 7 64bit Office 2007
Novice
 
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