Excel: How do I add columns with the same name together?

Question

Hard to explain but I'm going to try. Consider "|" to represent a new column in my example. I want to take a bunch of numbers that have the same description in the field to their left... most likely some of them on separate Sheets of a document, and add them together WITHOUT actually specifying cell numbers. I want it to automatically find anything with that word, and add it. I'm thinking there must be a way to have Excel recognize the word with an "if" function or something? So here's an example so you'll see what I want to accomplish:

Sheet1 > Groceries | 100
Sheet2 > Groceries | 50
Bills | 124
Sheet3> Clothes | 458
Groceries | 50
Sheet4(Summary)> Groceries = 200
Clothes = 458
Bills = 124

Get it? Ok... so how do I do it? Key word: WITHOUT specifying the cell numbers!

Answer 1

When creating your Pivot Table, use the wizard (Data - Pivot Table) and on the first tab, select "Multiple Consolidation Ranges" instead of "Microsoft Excel list or database". This will allow you to select many ranges of data.

Then, on Step 2a of 3, allow it to create the page fields for you.

On Step 2b of 3, select the worksheet range you seek from the first tab, click Add, then select the next on the second tab, click Add, etc. Add your fields to your pivot table for summary and it'll add it up. If you add a date or month column as well, you can make that your page filter on the pivot table.

In Step 3, use the Layout button to layout your fields and you'll have your summary.

Answer 2

It is easier if you put all in a single sheet and use pivotables to get a summary report.

Answer 3

Hello Dear
Use copy paste to do that OR
GO to bellow link to learn more about Excel
http://www.usd.edu/trio/tut/excel/
Good luck