Sum function

[Muthukrishnan V]

Excel 2003 - What is the better way of inputting the formula for the following function?

+E32+E33+E34+E35+E42+E43+E44-E49-E50-E51-E52+E65+E66+E67-E74-E75-E76-E77+E81-E87

 

[Sal Paradise]

Try:
=SUM(E32:E35,E42:44,E65:E67,E81)-SUM(E49:E52,E74:E77,E87)

 

[jeffreybrown]

Sal,

Just one miss on a letter.

Try:
=SUM(E32:E35,E42:E44,E65:E67,E81)-SUM(E49:E52,E74:E77,E87)

 

[Sal Paradise]

Nice catch. Thank you.