+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Countifs? HELP? in Technical; Hi Trying to use a count ifs formula. =COUNTIFS(K3:K246,"A",K3:K246,"B",K3:K246,"C") its to count the number of A - C grades in ...
  1. #1
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Countifs? HELP?

    Hi

    Trying to use a count ifs formula.

    =COUNTIFS(K3:K246,"A",K3:K246,"B",K3:K246,"C")

    its to count the number of A - C grades in one column, but it keeps returning a value of 0.

    can anybody see where i might be going wrong? or suggest an alternative to countifs ?


    thanks

    James

  2. #2

    Join Date
    Oct 2008
    Location
    Manchester
    Posts
    64
    Thank Post
    1
    Thanked 13 Times in 13 Posts
    Rep Power
    15
    Could you modify this.
    IF Question - MrExcel Message Board

  3. Thanks to pavlovs_dog from:

    jimbojames136 (3rd March 2011)

  4. #3
    tdawson's Avatar
    Join Date
    Jun 2006
    Location
    Leicester
    Posts
    13
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    17
    It's not pretty but won't this do the job?

    =SUM(COUNTIF(Grade,"a"),COUNTIF(Grade,"b"),COUNTIF (Grade,"c"))

    Either that or insert a Pivot table which will count everything up for you.

  5. Thanks to tdawson from:

    jimbojames136 (3rd March 2011)

  6. #4
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks Guys, it may be messy but it works

SHARE:
+ Post New Thread

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
  •