So I have been trying to add refrenced cells but each time I input the sum formula is get 0 as an answer. I did a search online and realised that I'm to use the indirect formula but I just caot 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 refrenced cells. Any help will be greatly appreciated
Oops I caot post pictures at the moment but I hope the description of my headache will be understood from the three points below:
Please note that the values in A2 to H2 are referenced from another sheet.
Thanks in advance.
برچسب:
نویسنده: استخدام کار