WPS工作表中如何通过函数对报销表进行汇总？

1、看一下事先准备的表格（如图）

2、报销、票据金额是否一致。点击G7输入公式：=IF(E7-F7<>0,"不一致","一致")（如图）

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,"已报")（如图）

4、2月已报金额汇总。点击D4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/2/1",$N$7:$N$500,"<=2021/2/28",$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,"已报")（如图）

6、4月已报金额汇总。点击F4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/4/1",$N$7:$N$500,"<=2021/4/30",$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,"已报")（如图）

8、6月已报金额汇总。点击H4输入公式：=SUMIFS($E$7:$E$500,$N$7:$N$500,">=2021/6/1",$N$7:$N$500,"<=2021/6/30",$K$7:$K$500,"已报")（如图）

9、未报销个数汇总。点击J4输入公式：=COUNTIF($K$7:$K$500,"未报")（如图）

10、未报销金额汇总。点击L4输入公式：=SUMIF($K$7:$K$500,"未报",$E$7:$E$500)（如图）