excel如何制作出纳账，快速核对各账户金额

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，向右拉动完成公式填充