1、看一下事先准备出纳账
2、点击C4单元格，输入筇瑰尬哇公式：=SUMIFS($F$9:$F$20,$E$9:$E$20,C3,$B$9:$B$20,">="&EOMONTH(TODAY(),-1)+1,$B$9:$B$20,"<="&EOMONTH(TODAY(),0))，按enter键结束
3、点击C5单元格，输入筇瑰尬哇公式：=SUMIFS($G$9:$G$20,$E$9:$E$20,C3,$B$9:$B$20,">="&EOMONTH(TODAY(),-1)+1,$B$9:$B$20,"<="&EOMONTH(TODAY(),0))，按enter键结束
4、点击C6单元格，输入公式：=SUMIFS($F$9:$F$20,$E$9:$E$20,C3)-SUMIFS($G$9:$G$20,$E$9:$E$20,C3)，按enter键结束
5、接着，选中区域C4:C6，向右拉动完成公式填充
