I have workbook with 12 worksheets (sample has only Jan and Feb sheets) from which I want to summary data from all worksheets onto a single Summary (see tab on worksheet) sheet. Each worksheet has three sections: Income, Expense, and Spending. Each section has several columns. From each of these sections I want to get and summarize data from three of the columns: Description, Amount and Date. So from INCOME section of all worksheets (i.e. Jan, Feb,…) I want to get and summarize data from Description, Amount and Date column; from EXPENSE section of all worksheets I want to get and summarize data from Description, Amount and Date column; and from SPENDING section of all worksheets I want to get and summarize data from same columns.
For example, from Income section of all worksheets, I want Excel to look at the Descriptions column and total the Amounts for all items with the same description, that fall between two dates. Then Excel look at Expense section Description column and total the Amounts for all items with the same description, that fall between two dates. Then do the same for the Spending section.
The descriptions to be totaled cannot pre-exist on the summary sheet, so I need Excel to fine each unique description, and list it once on summary sheet, even if it exist multiple times in Income, Expense or Spending section of a particular month, then calculate the total.
I’ve attached a sample file. The SUMMAY EXAMPLE sheet is what I would like the result to look like on SUMMARY sheet, but I’m open to a different layout.
Can any one help?
Thanks in advance.
Bookmarks