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.
Bookmarks