1. Click on an empty cell in your spreadsheet. 2. Type an " sign. 3. Type the following formula into the cell: UM(A1:A10) 4. Replace "A1:A10" with the cell locations
http://www.ehow.com/how_6804653_entersumseveral...

SUM adds a range of numbers. EXAMPLE: Find the sum of the contents of cells B1 through B32. =SUM(B1:B21) You also can combine several ranges to get a single sum. =SUM(B1:B12,B34:B42
http://wiki.answers.com/Q/What+kind+of+formula+is+...

The SUM function in Excel is specifically designed to add values from different
http://www.chacha.com/question/whatisthesumfor...

ok ************************* Choose a blank bit of sheet and put in the cell refs you want to lookup, 1.2 c1. 24 c2 48 etc (you can simply do +c1+24, easier) next on D1, use =HLOOKUP
http://answers.yahoo.com/question/index?qid=200809...
