| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totalling coded values
Given a table of exam grades and corresponding marks as below, how do I sum a
series of grades? E.g if grades are A*,A, C & D how do I total the marks of 58, 52, 40 and 34. Assume data is columns B to J with (some) blank column entries. TIA. Codes Marks A* 58 A 52 B 46 C 40 D 34 E 28 F 22 G 16 U 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totalling Values From The Same Cell In 12 Worksheets Onto New Shee | Excel Worksheet Functions | |||
| Totalling Values From The Same Cell In 12 Worksheets Onto New Shee | Setting up and Configuration of Excel | |||
| Convert Hard-coded cell values to constants | Excel Discussion (Misc queries) | |||
| Totalling unique values | Excel Discussion (Misc queries) | |||
| Totalling values across columns | Excel Worksheet Functions | |||
Threaded Mode
