Thread: [Solved] COUNTIF - A vs. AA???
View Single Post
 
Old 12-30-2020, 05:56 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
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