Microsoft Office Forums - View Single Post - Create a formula to count all occurances of HH but multiply by 0.5 first

Thread: Create a formula to count all occurances of HH but multiply by 0.5 first

View Single Post

Old

06-13-2016, 01:04 PM

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

Quote:

Originally Posted by gebobs

View Post

=countif((d21:ct26,"h")+countif((d21:ct26,"hh")*0. 5

Somehow, it appears a few extraneous parentheses were added above. Try this...

=countif(d21:ct26,"h")+countif(d21:ct26,"hh")*0.5

Reply With Quote