Calculate total from two sheets

**Anibha Jain** · 07-11-2013, 06:35 AM

Please find attached file. Total of Sheet 1 and Sheet 2 has to be calculated in Sheet 3.

Thanks,

Anibha

**martindwilson** · 07-11-2013, 06:51 AM

since both sheets are identical in layout in b3 of sheet 3 put =SUM(Sheet1:Sheet2!B3) fill across and down

**Anibha Jain** · 07-11-2013, 07:06 AM

Thanks! I did not realise that i have typed the same format. Please find attached a fresh file.

The requirement is again to calculate the total.

**martindwilson** · 07-11-2013, 08:25 AM

ah i see the dates are different
then try attached

**Anibha Jain** · 07-16-2013, 03:03 AM

Thanks

Its working!

Sorry for replying soo late!!!!

Re: Calculate total from two sheets