Microsoft Office Forums Countif multiple same range

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 03-31-2019, 08:10 AM
Greggey1 Greggey1 is offline Countif multiple same range Windows Vista Countif multiple same range Office 2016
Novice
Countif multiple same range
 
Join Date: Mar 2019
Posts: 10
Greggey1 is on a distinguished road
Default

Quote:
Originally Posted by bosco_yip View Post
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!
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft