PNS Kilbirnie 2.0 > NW Newtown 1.0 > NW Island Bay 1.5 > NW Metro 1.0 > PNS Kilbirnie 1.0 > > > eg: Need to add only the “PNS Kilbirnie ” totals but these are also in other > columns similar to above. At the moment these two columns are …

See the article here:
Sum in another cell with reference to another