Countif
 

Hi,
I have a list of student exam grades that include A and A*. However, I
can't use countif to calculate the number of A* (returns the total of A and
A*) trying to countif the * doesn't work either (* is used as a wildcard and
returns everything!). I've tried using single quotation marks but to no
avail!

Any suggestions?

Thanks

Countif
 

Hi

Try
=COUNTIF(A1:A100,"=A~*")

--
Regards

Roger Govier


"Tubthumper" wrote in message
...
Hi,
I have a list of student exam grades that include A and A*. However,
I
can't use countif to calculate the number of A* (returns the total of
A and
A*) trying to countif the * doesn't work either (* is used as a
wildcard and
returns everything!). I've tried using single quotation marks but to
no
avail!

Any suggestions?

Thanks

Countif
 

=COUNTIF(A1:A100,"A~*")

"Tubthumper" wrote:

Hi,
I have a list of student exam grades that include A and A*. However, I
can't use countif to calculate the number of A* (returns the total of A and
A*) trying to countif the * doesn't work either (* is used as a wildcard and
returns everything!). I've tried using single quotation marks but to no
avail!

Any suggestions?

Thanks

Countif
 

Just to add...

* and ? are wild cards.

To find them (edit|Find or =sumif(), =countif(), you use a ~ to tell excel that
you want to treat the next character as that character--not the wild card.

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~



Tubthumper wrote:

Hi,
I have a list of student exam grades that include A and A*. However, I
can't use countif to calculate the number of A* (returns the total of A and
A*) trying to countif the * doesn't work either (* is used as a wildcard and
returns everything!). I've tried using single quotation marks but to no
avail!

Any suggestions?

Thanks

--

Dave Peterson

Countif
 

Hi Dave

I guess I was being too darned lazy again with my response.
Thanks for providing the OP with the detailed reason why the tilde ~
makes it work.

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
Just to add...

* and ? are wild cards.

To find them (edit|Find or =sumif(), =countif(), you use a ~ to tell
excel that
you want to treat the next character as that character--not the wild
card.

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~



Tubthumper wrote:

Hi,
I have a list of student exam grades that include A and A*. However,
I
can't use countif to calculate the number of A* (returns the total of
A and
A*) trying to countif the * doesn't work either (* is used as a
wildcard and
returns everything!). I've tried using single quotation marks but to
no
avail!

Any suggestions?

Thanks

--

Dave Peterson