AutoSum Help

[Guest]

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!!

 

[Guest]

=SUM(Sheet1:Sheet4!H3)

 

[Guest]

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