Microsoft Office Forums - View Single Post - Countif multiple same range

Thread: Countif multiple same range

View Single Post

Old

03-30-2019, 02:48 AM

bosco_yip

bosco_yip is offline

bosco_yip uses Windows 10

Windows 10 bosco_yip uses Office 2016

bosco_yip uses Office 2016

Office 2016

Novice

Join Date: Feb 2019

Location: Singapore

Posts: 7

bosco_yip is on a distinguished road

Default

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

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

Regards
Bosco

Reply With Quote