Microsoft Office Forums - View Single Post - [Solved] How do you count how often a specific value occurs in single changing cell?

Thread: [Solved] How do you count how often a specific value occurs in single changing cell?

View Single Post

Old

09-02-2014, 11:06 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs 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