I would to know of a formula that would sum up the totals for a group, that is define in some cells.
For example if the Chicago group consist of stores Chi.a and Chi.b that are defined in cells E1 and E2.
I would the total of both groups in cell E4. ie. Chi.a + Chi.b = 6
I tried the sumifs but it only work with one criteria. =SUMIFS(B4:B8,A4:A8,E1)
as soon an put the second criteria (cell E2) it returns a 0.
Any help would be appreciated.