Add data in columns from 2 different sheets

[Amir11177]

Hello All,


I need to add monthly profit and loss data from two different excel sheets. Lets say for example, for Jan 2011 my data contains 5 columns, i need to add FEB and MAR to Jan 2011 sheet without typing data for each line item. Is there a way to import values from FEB and MAR and add it to Jan 2011 sheet.


I will appreciate your guidance.


Thank you

Amir

 

[Hui]

@Amir


Firstly, Welcome to the Chandoo.org Forums.


You can add data from other sheets in a number of ways


Single cells

=B2+Sheet2!B2+Sheet3!B2


Where the sheets ranges are diferent

=B3+SUM(Sheet2!C3:E3,Sheet3!M3:O3)


Where the sheets ranges are the same

=B4+SUM(Sheet2:Sheet3!C4:E4)

 

[Amir11177]

Thank you so much Hui. I will test it out.