Use QGIS expressions with the aggregate function sumsum(), grouping it by the common part of the CFSAUID"CFSAUID" attribute. For this, define an expression that returns this common part, here returning the first two characters with left (CFSAUID, 2).
So the whole expression looks like:
sum (value, group_by:= left =left(CFSAUID,2))
                