In Sheets, provinces are listed down H2:H5 and channel names across I1:J1. In I2, type the SUMIFS that fills both down and across to rebuild the prov × channel Sum pivot.
In Sheets, provinces are listed down H2:H5 and channel names across I1:J1. In I2, type the SUMIFS that fills both down and across to rebuild the prov × channel Sum pivot.
Answer
=SUMIFS(D2:D13, B2:B13, H2, C2:C13, I1)
Sum range first. H2 keeps the province column fixed when filling right; I1 keeps the header row fixed when filling down. I2 = 930.