count Students' Grades

[Guest]

Hi,

I hope someone can help,

I am trying to count the number of grades in a column

The grades range is ** AA BB CC DD EE FF GG
(** is the highest and GG is the lowest).

I am using the countif() function at the bottom of a column of students'
grades;

It should tell me how many students get each type of grade, and it does
for grades AA to GG, but for grade ** (double star) it gets confused.

But then the star symbol is a wild card symbol, quotes and back slashes
don't seem to work.

Does any one have any ideas?

Thanks

=COUNTIF(E3:E18,"**") ---> this ones gets confused
=COUNTIF(E3:E18,"AA") --> this one works
=COUNTIF(E3:E18,"BB") --> this one works
etc.
=COUNTIF(E3:E18,"GG") --> this one works

 

[Frank Kabel]

Hi
the * is used as a wildcard in COUNTIF
One workaround: Try
=COUNTIF(E3:E18,"~*~*")

or use
=SUMPRODUCT(--(E3:E18="**"))

 

[Trevor Shuttleworth]

=COUNTIF(E3:E18,"~*~*")

Regards

Trevor

 

[Bob Phillips]

You could count all of the others, and take the total of those from the
total of them all, de facto this gives the ** total.

Or you could try

=COUNTIF(E3:E18,"<A")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi nospam!

Use:

=COUNTIF(E3:E18,"~*~*")

The trouble with the * is that it is one of the wild cards used by Excel.
The ~ tells Excel that the * is f'real!
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Thanks Frank

=COUNTIF(E3:E18,"~*~*")

This worked great

 

[Guest]

Thanks everyone that has made my life a lot easier.

What service form this group. Amazing, thanks again