我想要一个个人日常开销的excel表格模板,最好连工资,**,**都加上。比较齐全的那种,谢谢了!
示意图如下,在l3中输入公式:=if(a3="","",sum(b3:k3)),公式下拉。在m3中输入公式:=if(a3="","",if(a3=a2,"",if(countif(a3:a8,a3)=6,sum(l3:l8),if(countif(a3:a7,a3)=5,sum(l3:l7),if(countif(a3:a6,a3)=4,sum(l3:l6),if(countif(a3:a5,a3)=3,sum(l3:l5),if(countif(a3:a4,a3)=2,sum(l3:... 20210311