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
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago