I don't think the formula you provided would work. You are only seeing one instance of the G column value "Full", whereas I may have two instances of the same value in the 3 groups.
I'm attaching the full spreadsheet to this thread to show the remaining groups as well as my efforts on doing totals.
Thanks
|