Effectively I want to give numeric scores to alphabetic grades and sum them. In Excel, putting the `LOOKUP`

function into an array formula works:

```
{=SUM(LOOKUP(grades, scoringarray))}
```

With the `VLOOKUP`

function this does not work (only gets the score for the first grade). Google Spreadsheets does not appear to have the `LOOKUP`

function and `VLOOKUP`

fails in the same way using:

```
=SUM(ARRAYFORMULA(VLOOKUP(grades, scoresarray, 2, 0)))
```

or

```
=ARRAYFORMULA(SUM(VLOOKUP(grades, scoresarray, 2, 0)))
```

Is it possible to do this (but I have the syntax wrong)? Can you suggest a method that allows having the calculation in one simple cell like this rather than hiding the lookups somewhere else and summing them afterwards?