+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, Excel - Countif ("A*") problem in Technical; Hello All, I want to COUNTIF all the pupils who have an "A*" grade in a spreadsheet. =COUNTIF(GradeRange,"A*") However, Excel ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel - Countif ("A*") problem

    Hello All,

    I want to COUNTIF all the pupils who have an "A*" grade in a spreadsheet.

    =COUNTIF(GradeRange,"A*")

    However, Excel sees the astrix as a wildcard and counts any cell with an "A" in it.

    Is there a way of instructing excel not to see the '*' as a wildcard criteria?

    Thanks,

    Ben

  2. #2

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,840
    Thank Post
    25
    Thanked 91 Times in 71 Posts
    Rep Power
    51
    Try

    =COUNTIF(GradeRange,"=A~*")

  3. 3 Thanks to Simcfc73:

    Cache (6th May 2009), Lee_K_81 (6th May 2009), park_bench (6th May 2009)

  4. #3

    Join Date
    Jan 2007
    Location
    Birmingham
    Posts
    807
    Thank Post
    29
    Thanked 36 Times in 24 Posts
    Rep Power
    26
    Quote Originally Posted by Simcfc73 View Post
    Try

    =COUNTIF(GradeRange,"=A~*")
    Never knew that. Much better than my solution of suggesting manually changing all A* to A+

  5. #4

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Spot on.

    Thanks very much.

    Ben

  6. #5
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,229
    Thank Post
    462
    Thanked 178 Times in 175 Posts
    Blog Entries
    3
    Rep Power
    65
    Wow, never realised that.

    I did the same as above and replaced A* with A+. Ah well.

  7. #6

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,953
    Thank Post
    1,347
    Thanked 1,800 Times in 1,118 Posts
    Blog Entries
    19
    Rep Power
    597
    Another who did A+ instead of A*

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 12
    Last Post: 13th March 2009, 05:13 PM
  2. ATEN KVM "Out of Range" problem
    By randle in forum Hardware
    Replies: 6
    Last Post: 2nd July 2008, 12:49 PM
  3. "Error 403" & "Moved to here" message
    By tech_guy in forum Windows
    Replies: 4
    Last Post: 24th January 2008, 01:07 PM
  4. Excel "HELP"
    By mahlon in forum Windows
    Replies: 3
    Last Post: 4th May 2007, 11:15 AM
  5. Replies: 6
    Last Post: 28th September 2006, 07:06 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •