hi, I got a problem here.

I want to use function total up all the A1 value in first sheet to current sheet, how can I get it?

=SUM(sheet1:(CURRENT SHEET)!A1)