Summing cells in spreadsheets

[pbhogal]

Hello

Suppose that I have hundreds of psreadsheets that have the same exact format.

Now suppose that I want to sum up the numbers in a number of cells, each cell in the result will contain the sum of all the numbers in the same cell from all of the worksheets.

How do I do it WITHOUT opening all the spreadsheets at the same time?

Thanks.

 

[prabby25101981]

So if the sheets are named with numbers, you can simply type this formula

=SUM('1:2'!A1)

I have taken two sheets here. You can take any number of sheets.

Hope it helps !