Hi
=SUM('sheet1:Sheet10'!B2)

"HJK" wrote:

How do I get a total of cells in different worksheets. For example, cell B2
in worksheet 1, B2 in worksheet 2, etc.