Sum range over sheets in google spreadsheets

I think the answer to this is that it isn't possible on google sheets as yet.

Would love if Sheets actually had similar functionalities.

You just need to mention the sheet names as well. Though, you'll have to mention each sheet name seperately. Something like this would work