Microsoft Office Forums - View Single Post - [Solved] Countif returns 0 value

Thread: [Solved] Countif returns 0 value

View Single Post

Old

02-07-2017, 09:13 PM

janielsean janielsean is offline

janielsean is offline

janielsean uses Windows 10

Windows 10 janielsean uses Office 2010 64bit

janielsean uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Feb 2017

Posts: 3

janielsean is on a distinguished road

Default

Thanks xor, tried it nothing happened but "#value!" error...

Quote:

Originally Posted by xor

View Post

Try

=SUMPRODUCT(--(--(LEFT(A2:A10,3))=120))

Reply With Quote