SUM same Range different worksheets

[audax48]

I need some help, please

I have a workbook with 50 worksheets....Column D of each worksheets is populated with numbers...I need to sum Column D of each worksheet and put respectively the result in Cell E1 of each worksheet.

Thank you a lot

[Cutter]

If you have a cell on each sheet that sums column D for that particular sheet then you can sum those cells like:

=SUM(Sheet1:Sheet50!D1) sums all D1 cells from sheet1 to sheet50

but you have to make sure no sheets are between the first and last named sheets that are not to be included in the SUM()

[audax48]

Thank you for your answer...but I don't need to sum all worksheets...I need to sum for ex. Sheet1 column d and put the result in the same Sheet in E1...then sum Sheet2 column d and put the result in Sheet2 in E1.....the same until Sheet 50
Thank you

[HSV]

Please Login or Register  to view this content.

[audax48]

Thank you Harry...work 100%