easy way to SUM multiple cells

[MAP]

Experts, I want to know from you if there is a better way to do a =SUM.

(A) consider the following situation I have in one of my worksheets where I am trying to add various cells in the same row:
="Production YTD "&TEXT(SUM(D67,H67,L67,P67,T67,X67,AB67,AF67,AJ67,AN67,AR67,AV67),"$ ##0.00")

(B) or the following situation where I am attempting to add the same cell in different worksheets:
='1'!B8+'2'!B8+'3'!B8+'4'!B8+'5'!B8+'6'!B8+'7'!B8+'8'!B8+'9'!B8+'10'!B8+'11'!B8+'12'!B8+'13'!B8+'14'!B8+'15'!B8

Thank you for sharing your Excel talents.

 

[T. Valko]

Just out of curiosity. If you type from right to left
)
1)
A1)
!A1)
and so on

Or if you copy+paste

M.

Trying both of those techniques causes (my copy of) Excel 2002 to crash!

Both work OK in Excel 2007.

 

[MAP]

guys, my Excel 2003 also accepts the =SUM('*'!A1) with no problems... Of course, just like T.Valko's experience, my Excel 2003 converted the special formula in sheet1 to =SUM(sheet2:sheet3!A1) as soon as I pressed enter..

So, supposedly, versions older than Excel 2003 did not have the capabilities of '*'... This was a nice shortcut presented by Marcelo Branco... without him, this trick would have just gone unnoticed outside of John Walkenbach's "Excel 2007 Tips & Tricks" book.

THANKS to all for the great education.