顯然用透視表啊,按某個關鍵字直接分類求和,可是很多朋友懼怕使用新的工具,其實完全沒有必要,你跟著我學習這一個視頻就知道透視表有多簡單,有多好入門了!!{!--PGC_VIDEO:{"thumb_height":360,"file_sign":"8c881a43ba087b1721251b8858e1cea8","vname":"","vid":"9c1e804dbc114512b7a153312b75e9a6","thumb_width":480,"vu":"9c1e804dbc114512b7a153312b75e9a6","src_thumb_uri":"6d910008deabe8d38d4f","sp":"toutiao","update_thumb_type":1,"vposter":"https://p3-sign.toutiaoimg.com/mosaic-legacy/6c290008dd7c495b9123~noop.image?x-expires=1994901009&x-signature=O4tOjOQC43AKb45BF3S7SWdm7lM%3D","video_size":{"high":{"duration":277.28,"h":480,"subjective_score":0,"w":640,"file_size":5343557},"normal":{"duration":277.28,"h":360,"subjective_score":0,"w":480,"file_size":4091992}},"duration":277.28,"thumb_url":"6c290008dd7c495b9123","thumb_uri":"6c290008dd7c495b9123","md5":"8c881a43ba087b1721251b8858e1cea8"}--}

透視表是真正的神器,如果不學就太可惜了,函數你可以不學,vba可以不學,透視表絕對要學,更多的案例可以在頭條app里搜索excel880透視如果全都看完秒變高手!