+ Reply to Thread
Results 1 to 3 of 3

Count cells with this answer and total

  1. #1
    Registered User
    Join Date
    01-06-2005
    Posts
    8

    Count cells with this answer and total

    This has to be a COUNT function but I can't get it right.

    I am trying to get a large spreadsheet to tally certain answers across the page. It is bowl games in which each person selected one team or the other my entering the appropriate abbreviation. On the far right I want it to simply count each cell with a correct answer in it. There were 20 games so if the correct answer is in 15 cells then it should total 15. I was able to do it by eliminating the wrong answers and just counting the cells left with info. I would rather do it without having to do this and I know it can be done simply, but not by me! Thanks. Please email suggestions.

    Joe Cannata
    Attached Files Attached Files

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451
    Try the COUNTIF function.

    =COUNTIF(the range to search,what to count)

  3. #3
    Registered User
    Join Date
    01-06-2005
    Posts
    8

    Did It

    I have tried using COUNTIF. I count the range from left to right BUT when I input what to count it only counts the last one I enter. There are 20 answers that are either "this" or "that" but the problem seems to be that for each square it is not looking for just one same right or wrong answer. Each cell has a right or wrong answer AND the next cell had a completely different right or wrong answer. I tried COUNTIF (range left to right,correct answer, correct answer, etc.) but it only counts one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1