RE: Totalling coded values

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Teethless mama <Teethlessmama@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 2 Apr 2008 19:41:01 -0700

Criterias - defined name range (eg. A2:A5)
Codes - defined name range (eg. B2:B10)
Marks - defined name range (eg. C2:C10)

=SUMPRODUCT((ISNUMBER(MATCH(Codes,Criterias,0)))*Marks)

Adjust your range to suit

"Toppers" wrote:

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: Toppers

References:
- Totalling coded values
  - From: Toppers

Prev by Date: RE: week ending
Next by Date: RE: Help to build a Look Up Function or What Ever Function Excel 2
Previous by thread: RE: Totalling coded values
Next by thread: RE: Totalling coded values
Index(es):
- Date
- Thread