Countif multiple same range

		Microsoft Office Forums > Microsoft Excel > Excel
Countif multiple same range

03-30-2019, 05:32 AM

Greggey1

Windows Vista Countif multiple same range

Office 2016

Novice

Join Date: Mar 2019

Posts: 10

Quote:

Originally Posted by bosco_yip

Or…....................

=SUMPRODUCT(0+(LEN(B5:B14)>0)*(LEN(B5:B14)-LEN(SUBSTITUTE(B5:B14,"/",""))+1))

Regards
Bosco

That's very close. The only thing is if someone who enters a number not beginning with 9 I don't want it to count. Thanks for the help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with multiple criteria	Marcia	Excel	5	02-17-2019 08:16 AM
Use countif across multiple tabs for a column	marconexcel	Excel	6	02-21-2017 05:38 AM
Sumif with multiple sum range	Haha88	Excel	6	10-29-2015 03:26 AM
multiple criteria and within a range?	hhppyy	Excel	1	07-17-2015 08:17 AM
Using range object to work with multiple columns	kjworduser	Word VBA	1	11-01-2013 03:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 PM.