Expert: Philip Buckley - 9/16/2009

Question
I have one excel sheet. In that sheet I have entered 10 heading in column wise like B1 is Company name, C1 is Profit, D1 is Sales et.... and in raw wise I have 12 months (Jan-Dec. What I need is how to find out how much sales, profit or sales done in month wise from table (B2:K13. Pl. help and give a excel formula for soling this problem

Answer
Joseph,

The best way to handle such data is using a PivotTable.

To use this do the following:

1. Click somewhere on your raw data
2. Select "Data"
3. Select "PivotTable and PivotChart Report..."

This will bring up the "PivotTable and PivotChart Wizard"

4. Select "Next"
5. Make sure that the range selected includes all of your data, if not use your mouse to select the rows and columns you want to include.  INCLUDE COLUMN TITLES IN THIS RANGE.
5. Select "Next"
6. Select "Layout"

This will bring up the "Layout Wizard"  Note on the right each column name shows as a tile while on the left there is an empty table.  Using your mouse drag the tiles into the sections labled:

"Column"
"Row"
"Amount"

Don't worry if you don't get it right the first time.  Once the table is set up in Excel, you can change it by dragging the tiles where you want them to be.

7. Select "OK"
8. Select "Finish"

This will set up the table for you.  If you don't like how the table is set up, you can change it by dragging the tiles to the appropriate places.  This type of table is a little tricky to learn how to use, but after a while it becomes very easy.