I have this line
=COUNTIF((AP3:AP43),"A*")+COUNTIF((AP3:AP43),"A")+COUNTIF((AP3:AP43),"B")+COUNTIF((AP3:AP43),"C")
designed to count up all the students in a column achieving A* to C, however in every case it is counting higher than the actual number. Through trial and error, I realised it is the A* part that is throwing it out but I don't know why. How do I get it to include a proper count with an A* entry?
"A*" it will count A and A*
or
"A~*" it will count only A*
Aha! Thank you again
You are welcome again
Got help? As thanks give a star* & mark thread SOLVED! (Thread Tools->Mark thread as Solved) Thank You
btw. you can use much shorter formula, like: =SUM(COUNTIF(AP3:AP43,{"A","A~*","B","C"}))
regards
In the COUNTIF function the asterisk * is a wildcard character which means any character(s) or no characters(s).
If this was your data:
Apple
Train
Adam
Sam
A
=COUNTIF(AP3:AP43,"A*")
Returns 3, counting Apple, Adam and A.
If you have data like this:
A*
B+
C-
A*
F
And you want to count entries that are A*...
=COUNTIF(AP3:AP43,"A~*")
The tilde character tells Excel to treat the asterisk * as the literal character and not a wildcard.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks