集計
しゅうけい · shuukei · JLPT N1 · noun
totalization
🧮 集 = gather + 計 = count: gather the parts, count them up, get the total
Shuukei combines 集 (shuu, gather) and 計 (kei, count or measure). Gathering values and counting them up is exactly what aggregation means in statistics and spreadsheets.
集 — bird 隹 on top of tree 木
集 is an ideograph showing a bird (隹) perched on a tree (木). The original form depicted three birds gathering on a tree, later simplified to one. From 'birds flocking together' it extended to mean 'gather, collect, assemble,' and by extension 'collection' or 'volume' of writings.