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.