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

		Microsoft Office Forums > Microsoft Excel > Excel
Create a formula to count all occurances of HH but multiply by 0.5 first

06-13-2016, 01:04 PM

gebobs

Windows 7 64bit Create a formula to count all occurances of HH but multiply by 0.5 first

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Quote:

Originally Posted by gebobs

=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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Logic formula to only count patient once, even though they are listed multiple times	Carol Salcido	Excel	17	02-26-2014 03:57 PM
Word Count Formula	clau_dos	Word VBA	1	08-27-2013 02:05 PM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
multiply by incrementing by 5s	marynomore	Excel	2	03-27-2013 05:36 AM
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 PM.