Sumif with criteria for Row and Column

Hi,
Please help me out with the Solution to this problem..
The problem at hand is i need to add Data from two different tables as:

Sales(Jan) Sales(Feb) Sales(March)
Product1 23 12 11
Product2 11 8 9
Product3 10 6 10

Sales(Jan) Sales(March)
Product1 23 11
Product3 11 9
Product4 10 10


As you can see,We need to get the data into a new table in the form of:

Sales(Jan) Sales(Feb) Sales(March)
Product1 46 12 22
Product2 11 8 9
Product3 21 6 19
Product4 10 0 10

Basically i need to Just add the Data from Both tables whose Row and Column coefficients are Same.

That is,For Product 1, i need to add Sales in Jan,Feb and Mar from Table 1,but i can only add sales for Jan and Mar,but not for Feb from Table2....(Hence dynamically take relevant data from both tables..)

Hence similarly for Product2,its not present in table2,hence i need to show only data from table1 for it thats relevant..Please clarify my doubts regarding this..


I hope i am clear.! ...


Thanks a lot..

Actually it can be done with formula but better to do this with pivot. See example if it meets your requirments

If the tables are Pivots I would suggest you check out the GETPIVOTDATA function.

Use the above in conjunction with IFERROR to handle instances whereby a given combination does not exist in the Pivot, eg:

=IFERROR(GETPIVOTDATA(...),0)+IFERROR(GETPIVOTDATA(...),0)

where the first GETPIVOTDATA call is pointed at first PT and second at second PT

I think you will find the above approach pretty simple to setup.


If you need further assistance I would strongly advise posting a sample file that reflects your setup and desired output (dummy values obviously if confidential).