Counting cells with formulas
My underlying issue is that I'm trying to count cells that begin with a certain number. The data that is present in my SubCategory column is a picklist. Examples:
 106 COST BILLED IN ERROR
 110 FAILURE TO PURSUE PAYMENT AFTER INVOICE SUBMISSION
 201 CLIENT FAILED TO COMMUNICATE WITH FIRM
 207 PER CLIENT  COST IS NOT BILLABLE
So, I'm looking to count everything that begins with "1" or "2" and so on.
My first attempt was to create another column with a formula for "left" that pulled the first digit from the SubCategory column. However, when I do my Countif, the results are 0. I believe the Countif is looking at the formula & not the value.
Any suggestions on how to deal with this?
Comments

Can you post your exact LEFT and exact COUNTIF formulas? It may be that your COUNTIF is looking for a numeric value, but your LEFT formula is producing a text value.

Here is the LEN formula: =LEFT([Reason SubCategory]1, 1)
Here is the IFCOUNT formula: =COUNTIF({NY Credit Authorization Range 1}, "1")

Wrap your LEFT statement in a VALUE function.
=VALUE(LEFT([Reason SubCategory]1, 1))
and remove the quotes from around the 1 in your COUNTIF.
=COUNTIF({NY Credit Authorization Range 1}, 1)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!