Assume there is data for complaints received and complaints resolved for two years – 2009 and 2010 for some regions regions. Each Region has its own worksheet. There are three headings on each sheet – Particulars, 2009 and 2010. While the Particulars column has the text “Complaints received” and “Complaints resolved”, the year columns have number of complaints received and resolved.
The task is to create a Summary sheet which:
1. Show the consolidated figure of complaints received and complaints resolved for both years
2. Show the individual regions which make up the consolidated figure in 1 above.
In this workbook, you may see the data layout and four different ways of resolving the two tasks mentioned above.
You may also refer to the following related posts:
1. Summarise data from multiple worksheets with one condition
2. Summarise data from multiple worksheets with one condition – Part II
3. Summarise data from multiple worksheets
4. Summarise data from multiple worksheets with multiple conditions
5. Summarise data from multiple worksheets with multiple conditions – Part II
6. Summarise data from different cells of multiple worksheets
Show granular as well as total figures on the Summary sheet
{ 0 Comments }