Thread: [Solved] Countif returns 0 value
View Single Post
 
Old 02-07-2017, 01:06 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Try

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