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

1、看一下事先准备出纳账

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键结束

5、接着，选中区域C4:C6，向右拉动完成公式填充