how to sum multiple worksheet
how to sum multiple worksheets in a single sheet?
i tried using
=SUM(INDIRECT("'"&$I$1:$J$1&"'!i5"))
where i1 and j1 is the name of the worksheet and i5 is the value present in the all the different worksheets. Now i want that if i will the drag the cell downward and it will show i6,i7,i8 respectively..it should cells ref automatically.
Recent comments
5 years 45 weeks ago
6 years 31 weeks ago
6 years 43 weeks ago
6 years 46 weeks ago
6 years 47 weeks ago
7 years 6 days ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 9 weeks ago
7 years 9 weeks ago