I have two worksheets - 'Dashboard' and 'Source'.
I have a table of data in both sheets that is organised using two rows of headings:
Row 1 - Category 1, Category 2, Category 3
...and then underneath each category:
Row 2: Category 1a, Category 1b, Category 1c, Category 1d,.... and then..... Category2a, Category2b, Category2c, Category 2d, etc
Please note - In 'Source' sheet, each category ('Category 1', 'Category 2', etc) can appear more than once.
In the 'Dashboard' sheet, I need to sum the values found in my table of data in 'Source' sheet based on whether or not they sit under both 'Category 1' (in Row 1), and 'Category 1a' (in Row 2). I then need to do the same for 'Category 1' and 'Category 1b', etc. Essentially I think I need to use a nested index, but I don't know how to do it.
Any help on this would be greatly appreciated!
Unfortunately I can't attach a file on my work computer...
Thanks
Bookmarks