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

2025-01-05 18:03:32

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