Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #16  
Old 03-31-2019, 08:10 AM
Greggey1 Greggey1 is offline Windows Vista Office 2016
Novice
 
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 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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft