COUNTIF

SoMany · #1 12-28-2020, 08:02 PM

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*")

Purfleet · #2 12-28-2020, 11:02 PM

Looks like you always have a space after the A or AA or AAA, so =COUNTIF(G8:G18, "A *")

p45cal · #3 12-30-2020, 05:56 AM

perhaps subtract one from the other:

Code:

=COUNTIF(D8:D18, "A*")-COUNTIF(D8:D18, "AA*")

?

SoMany · #4 12-31-2020, 09:14 PM

Quote:

Originally Posted by Purfleet

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.

Purfleet · #5 01-01-2021, 12:50 AM

No problems, we have all missed an easy fix, so dont worry!

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 returns 0 value	janielsean	Excel	4	02-08-2017 08:56 AM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM