Totalling coded values
- From: Toppers <Toppers@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 2 Apr 2008 10:15:01 -0700
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
.
- Follow-Ups:
- RE: Totalling coded values
- From: Teethless mama
- RE: Totalling coded values
- From: Michael
- RE: Totalling coded values
- Prev by Date: Help to build a Look Up Function or What Ever Function Excel 2002
- Next by Date: RE: Totalling coded values
- Previous by thread: Help to build a Look Up Function or What Ever Function Excel 2002
- Next by thread: RE: Totalling coded values
- Index(es):
Relevant Pages
|
