I can't seem to get my formula right - I'm looking for a totals for groups A to M in my left hand column...or any archive value which appear in brackets (A) to (M).
There are few of these older values but they need adding to their corresponding current group, so any (A) has to be summed with the As.
At the moment I am using SUMIFS(Datasheet1!$L:$L, Datasheet1!$S:$S, B2) where B2 represents my groups A to M. I don't want a separate list of archive groups - just want to add another SUMIFS to add the bracketed group.
Have tried various formulae with "(" / ")" etc. added but to no effect.
Bookmarks