>Hi,
>
>An Excel workbook contain historical data. Each row contains year, product name, and sales for one invoice
>
>I want to create a separate sheet with this format, where xxxx is the sum of sales in all invoices for given product and year.
>
>

>            2009     2010    2011
>Product1    xxxx     xxxx    xxxx
>Product2    xxxx     xxxx    xxxx
>Product3    xxxx     xxxx    xxxx
>

>
>Does anyone know how to do this right in the Excel workbook?
>
>TIA,
>
>Alex

Use PivotTable wizard in Excel

Good Luck