1、看一下事先准备的表格（如图）
3、1月已报金额汇总。点击C4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/1/1",$N$7:$N$500,"<=2021/1/31",$K$7:$K$500,"已报")（如图）
5、3月已报金额汇总。点击E4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/3/1",$N$7:$N$500,"<=2021/3/31",$K$7:$K$500,"已报")（如图）
7、5月已报金额汇总。点击G4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/5/1",$N$7:$N$500,"<=2021/5/31",$K$7:$K$500,"已报")（如图）
9、未报销个数汇总。点击J4输入公式：=COUNTIF($K$7:$K$500,"未报")（如图）
