Include the Cell reference inside the parenthesis like so:

=SUM(Sheet2:Sheet3!A1)

"plainclothman" wrote:

I want to sum cell A1 in sheet1,...,sheet100 .I type (sheet1:sheet100)!$a$1
but it doesn't work