Count numbers that begin with
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
=SUMPRODUCT(--(LEFT(range,chars)="xx"))
=SUMPRODUCT(--(LEFT(B5:B11,2)="25"))
LEFT(B5:B11,2)
{"25";"25";"35";"45";"25";"45";"25"}
=SUMPRODUCT(--({TRUE;TRUE;FALSE;FALSE;TRUE;FALSE;TRUE}))
=SUMPRODUCT({1;1;0;0;1;0;1})
About KingExcel.info
Hi, I'm Mr KING Admin of KINGEXCEL.INFO .Thank you so much and I hope you will have an interesting time with KINGEXCEL.INFO. Mail: quantriexcel@gmail.com - PHONE : +84779313987.
Learn More →