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

Thread: Countif multiple same range

View Single Post

Old

03-31-2019, 08:10 AM

Greggey1

Greggey1 is offline

Greggey1 uses Windows Vista

Windows Vista Greggey1 uses Office 2016

Greggey1 uses Office 2016

Office 2016

Novice

The original poster

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