Countif multiple same range

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

#13

03-31-2019, 08:10 AM

Greggey1

Windows Vista Countif multiple same range

Office 2016

Novice

Join Date: Mar 2019

Posts: 10

Quote:

Originally Posted by bosco_yip

Then, the formula changed to

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

Regards
Bosco

Thank you!

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 03:47 AM.