excel表格怎样多列筛选排序?附图答:用sumif函数吧 在B19中输入:=sumif($A$2:$B$5,A19,$B$2:$B$5),在C19中输入:=sumif($C$2:$D$5,A19,$D$2:$D$5),在D19中输入:=sumif($E$2:$F$5,A19,$F$2:$F$5),在E19中输入:=sumif($G$2:$H$5,A19,$H$2:$H$5),然后向下拉复制公式,并在A19至24中输入...
excel表格怎样多列筛选排序?附图答:用sumif函数吧 在B19中输入:=sumif($A$2:$B$5,A19,$B$2:$B$5),在C19中输入:=sumif($C$2:$D$5,A19,$D$2:$D$5),在D19中输入:=sumif($E$2:$F$5,A19,$F$2:$F$5),在E19中输入:=sumif($G$2:$H$5,A19,$H$2:$H$5),然后向下拉复制公式,并在A19至24中...