Results 1 to 3 of 3

Count cells with this answer and total

Threaded View

  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

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