If I have numerical data in **A1** and **A2** then:

```
=SUM(A1:A2)
```

works and:

```
=SUM(INDIRECT("A1:A2"))
```

works and:

```
=SUM(A1,A2)
```

works but:

```
=SUM(INDIRECT("A1,A2"))
```

does not work. I am guessing that this is because `"A1,A2"`

is not a valid cell reference.

Can anyone explain why this is so, or point me to some online documentation that gives the explanation ??

## Best Answer

The SUM function takes a

list ofnumbers orreferencesas arguments. When you separate ranges with a comma, you are sending two arguments (references) to the SUM function.The INDIRECT function accepts

oneref_textargument(and the optional a1 argument) and "returns thereferencespecified by a text string."