I would like to identify how to use one formula in spreadsheet 3 that adds the values from Spreadsheet 1 according to all the codes that fall within a specific category (listed in spreadsheet 2)
For example to find the total for the category Dogs there are 2 codes 2010 and 7480 and then both of these codes are in spreadsheet 1 with values of £20 and £1050.98 totaling £1070.98.
Spreadsheet1
Col A (list of 4 digit codes) Col B (Amount)
2010 20.00
4329 50.43
7480 1050.98
Spreadsheet 2
Col A (list of 4 digit codes) Col B (Category Heading)
2010 Dogs
4329 Cats
7480 Dogs
Spreadsheet 3
Col A (Category Heading) Col B
Dogs
Cats
Hamsters
I do hope that this is possible and that more importantly someone understands my explanation.
Many thanks
Bookmarks