Results 1 to 4 of 4

Need help identifying the correct formula to use

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Not here, it's rubbish!
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    66

    Need help identifying the correct formula to use

    Hi,

    Wondering if someone can help me to solve a particular problem. An example sheet is attached.

    Here's the scenario; Several people submit pictures into an Art Competition and are awarded a Grade, A to F. Grade A earns 6 points, B earns 5 points, etc down to F earning 1 point.

    I know how to use the COUNTIF and SUMIF formulas to count the number of entries by each person, and each person's total score respectivley. The problem I'm having is identifying the correct formula to use to count the number of different awards, A to F, given each entrant (hence the blank cells in range E20 to J24).

    Can anyone suggest an Excel built-in Formula that will achieve this and the correct way to use that formula?

    Many thanks in advance.
    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