Pivot Table from several sheets

[MoMo1]

Hi,
I'm trying to create PT in Excel 2007 , the input for the PT should come from 2 sheets , the data in the sheets as the same headers ( the same # of col, same title name) .

I saw few answers , but I guess they were directed to Excel 2003 not 2007.

I know that the answer will be simple and obivious but I can;t fins it by myself.

 

[MoMo1]

thanks for your help and willingness.
the sum function doing only partial work , I need to so somekind of conditional sum.

sheet1
month amount
0804 100
0804 150
0804 50
0804 70

sheet2
month amount
0804 -70
0805 55

the consolidation should be : 0804 300 0805 55

 

[texasalynn]

take a look at these
http://www.mrexcel.com/forum/showthread.php?t=378414
http://www.mrexcel.com/forum/showthread.php?t=119020
http://www.mrexcel.com/forum/showthread.php?t=374936

 

[MoMo1]

Thnaks,
I ended up using the SumIF formula