Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2020, 08:02 PM
SoMany SoMany is offline COUNTIF - A vs. AA??? Windows 7 64bit COUNTIF - A vs. AA??? Office 2016
Advanced Beginner
COUNTIF - A vs. AA???
 
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
  #2  
Old 12-28-2020, 11:02 PM
Purfleet Purfleet is offline COUNTIF - A vs. AA??? Windows 10 COUNTIF - A vs. AA??? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Looks like you always have a space after the A or AA or AAA, so =COUNTIF(G8:G18, "A *")
Attached Files
File Type: xlsx Copy of MsForums example_Purfleet.xlsx (9.2 KB, 8 views)
Reply With Quote
  #3  
Old 12-31-2020, 09:14 PM
SoMany SoMany is offline COUNTIF - A vs. AA??? Windows 7 64bit COUNTIF - A vs. AA??? Office 2016
Advanced Beginner
COUNTIF - A vs. AA???
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default

Quote:
Originally Posted by Purfleet View Post
Looks like you always have a space after the A or AA or AAA, so =COUNTIF(G8:G18, "A *")
This worked. I feel dumb for even posting. Thank you.
Reply With Quote
  #4  
Old 01-01-2021, 12:50 AM
Purfleet Purfleet is offline COUNTIF - A vs. AA??? Windows 10 COUNTIF - A vs. AA??? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

No problems, we have all missed an easy fix, so dont worry!
Reply With Quote
  #5  
Old 12-30-2020, 05:56 AM
p45cal's Avatar
p45cal p45cal is offline COUNTIF - A vs. AA??? Windows 10 COUNTIF - A vs. AA??? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

perhaps subtract one from the other:
Code:
=COUNTIF(D8:D18, "A*")-COUNTIF(D8:D18, "AA*")
?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with COUNTIF MaineLady Excel 1 05-24-2019 02:53 PM
Help on Countif Error vikaskhengre Excel 1 04-09-2019 04:51 AM
COUNTIF - A vs. AA??? Countif returns 0 value janielsean Excel 4 02-08-2017 08:56 AM
Countif hockeytown Excel 3 01-05-2013 08:06 AM
COUNTIF - A vs. AA??? Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft