I have an Excel 2007 workbook. On one worksheet, I want to add up several regularly spaced values on another worksheet. I can easily do this with a very long sum formula without an array formula but it would be much simpler/nicer/easier to see what's going on if I could use an array formula. Below are a couple of my tries. Both seem to return only the first value out of the 8, instead of the sum of the 8. I am using `Ctrl`+`Shift`+`Enter`. Is there a way to do this? Am I making a silly mistake?

Try Number 1:

```
=SUM(INDIRECT("'Other Worksheet'!H" & {"12";"30";"48";"66";"84";"102";"120";"138"}))
```

Try Number 2:

```
=SUM(OFFSET(INDIRECT("'Other Worksheet'!H12"), {0,18,36,54,72,90,108,126},0))
```