I have been trying to add referenced cells, but each time I input the sum formula is get 0 as an answer.

I did a search online and realized that I need to use the INDIRECT function, but I just cannot make head or tail of it. At best, I am able to retrieve one number, but my intention is not retrieval alone but adding the numbers in the referenced cells.

What I need to do:

- In I2, sum A2:D2
- In J2, sum lowest 2 numbers in E2:H2
- In K2, sum I2 and J2

Please note that the values in A2 to H2 are referenced from another sheet.

`In J2, sum lowest 2 numbers in E2:H2`

? Because the 1 & 3 could not pose any serious challenge, right? – Vojtěch Dohnal Aug 30 '16 at 7:23