Saturday, July 27, 2013

Excel Consolidate

Let's assume you are a toy manufacturer, new on the market. This is your second year producing toys and need a report of total sales for every toy you produce. The data comes to you in a table format and you would like to sum the number of toys you sold in the last 2 years per category.