Sum values from different sheets to summary sheet

**puttu** · 10-18-2013, 10:05 AM

Hi,

I want to sum values from different sheets to summary sheet.

please see the attached workbook.

Thanks

**benishiryo** · 10-18-2013, 10:13 AM

hi puttu. use this in B5:
=SUM('Qtr1:Qtr4'!B5)

in Data tab -> Consolidate, you could do that too. i don't really use it, but you can explore

**alansidman** · 10-18-2013, 10:14 AM

Use the data consolidate function within Excel.

Look here

http://office.microsoft.com/en-gb/ex...010342300.aspx

**puttu** · 10-18-2013, 10:20 AM

if i want to use sum & indirect formula... how to do it. thanks you very much for your support & help.

**alansidman** · 10-18-2013, 10:23 AM

if i want to use sum & indirect formula... how to do it. thanks you very much for your support & help.

Why over complicate a simple matter. Perhaps there is more to this issue than you have told us.

**puttu** · 10-18-2013, 10:45 AM

Any how thank you very much.......

**newdoverman** · 10-18-2013, 10:49 AM

Enclosed are the two methods that have been described to you. I don't see why you want to do the calculation the way that you want.

Re: Sum values from different sheets to summary sheet