Countif returns 0 value

		Microsoft Office Forums > Microsoft Excel > Excel
Countif returns 0 value

FAQ

Thread Tools

Display Modes

02-07-2017, 12:57 PM

janielsean janielsean is offline

Windows 10 Countif returns 0 value

Office 2010 64bit

Novice

Join Date: Feb 2017

Posts: 3

Countif returns 0 value

I have a range of numbers in a column (example below)

I tried =COUNTIF(A2:A9,"120????") and it returned a zero result,
I want to count how many cell value starts with 120

1202616
1201925
805230

630154
1103057
1202559
1156971
1201577
1163681

thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to release hard returns?	markg2	Word	13	05-08-2023 01:38 PM
Formula returns wrong value	bobsone1	Excel	2	08-19-2014 12:12 AM
Selection.InlineShapes(1).ScaleHeight returns '0'	NobodysPerfect	Word VBA	1	06-29-2014 03:59 PM
No tabbing, no returns in forms?	rdowney1	Word	7	06-29-2012 08:35 AM
IF formula returns TRUE instead of evaluating COUNTIF	ColinC	Excel	4	12-28-2011 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:43 PM.