Thread: [Solved] COUNTIF - A vs. AA???
View Single Post
 
Old 12-28-2020, 08:02 PM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default COUNTIF - A vs. AA???
I can't find the formula for COUNTIF when looking for cells with a single "A" vs "AA". These cells also have numbers at the end.

The two variants in the example provided are
=COUNTIF(D8 : D18, "A*")
=COUNTIF(D8 : D18, "AA*")
Attached Files
File Type: xlsx MsForums example.xlsx (9.0 KB, 9 views)
Reply With Quote