Summing items from multiple spreadsheets.

[imported_unknown]

I would like to know how to summate multiple numbers from several different worksheets in the same workbook. I know that by using vlookup and adding several of these together it can be accomplished, but I am looking for a shorter route.

 

[rikrak]

Hi,

You want something like this?

=SUM(A1,Sheet1!B2,Sheet2!C3:C8)

 

[ctomblin]

When you are creating the formula, start with = then click the worksheet you want to include, click the cell on theat worksheet, do a + sign and repeat as necessary.

The formula will look like:
=Sheet1!A2+Sheet2!A7+Sheet3!B7