ExcelBanter - AutoSum Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AutoSum Help (https://www.excelbanter.com/excel-worksheet-functions/142480-autosum-help.html)

Stockwell43

AutoSum Help

Hello,

I have a workbook with 5 worksheets in it. I would like to autosum say cel
H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that?

Thanks!!

Barb Reinhardt

AutoSum Help

=SUM(Sheet1:Sheet4!H3)

"Stockwell43" wrote:

Hello,

I have a workbook with 5 worksheets in it. I would like to autosum say cel
H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that?

Thanks!!

Stockwell43

AutoSum Help

Thank you Barb, worked like a charm!!! I appreciate your help!

"Barb Reinhardt" wrote:

=SUM(Sheet1:Sheet4!H3)

"Stockwell43" wrote:

Hello,

I have a workbook with 5 worksheets in it. I would like to autosum say cel
H3 on sheet 5 and be able to total cell H5 from sheets 1-4. Can I do that?

Thanks!!

All times are GMT +1. The time now is 09:53 PM.