I'm currently trying to produce a spreadsheet as follows, but on a much larger scale:

![Spreadsheet example](https://i.stack.imgur.com/RagR8.png)

On the left is a table detailing manager's monthly sales, and on the right is a simple summation. Not quite as simple as I thought though!

The formula I need to calculate a managers sales has to say:

* Sum 'Sold A' and 'Sold B' if the cell to the left contains the manager's name.

The general idea I came up with was, for H3 (`Bob`'s sales):

```
SUMIF(D3:E7, INDIRECT(ADDRESS( ROW();COLUMN()-1))....

```

How to make the INDIRECT conditional?