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