Sum of one cell value in different excel sheets.

[aman1561]

Can you help to make sum of different cell content value in different sheets?
For example:
CAR1 has consumed 12 ltr in the month of Jun'14 (Sheet1), 14 ltr in the month of Jul'14 (Sheet2) and so on.
If we want to make summary as total month wise.
Regards,

[Pete_UK]

Is it always the same cell in each sheet that you want to sum? If so you can use this approach:

=SUM('first_sheet:last_sheet'!A1)

to add up the contents of cell A1 from all sheets between and including the first and last (in sequence as arranged at the bottom of the file window).

Hope this helps.

Pete

[aman1561]

No it may not be i the same place. We have to pick the value with name/description (CAR!) it self.

Regards,