Hi

I have data with different fields like product name, region and year wise

Data as follows
In A1 column - All the product
In B1 column 4 regions (north, south, east and west)
In Y column 2006 totals product wise
In Z column 2007 totals product wise

*total projects are divided into 4 regions,

Now I want to calculate product wise region wise total for 2006 year and so on
(In simple way I want to calculate total sale for x product in north region for 2006)

I think sumif function will work in this case, but I can't apply it correctly.
Can any one help me?
Thank you in advance - Sagar