在 Excel 2007 中,以下公式可满足题述要求:
1. 婚宴场次:=COUNTIFS($A$2:$A$8,F2,$B$2:$B$8,"婚宴")
2. 婚宴金额:=SUMIFS($C$2:$C$8,$A$2:$A$8,F2,$B$2:$B$8,"婚宴")
3. 生日宴场次:=IF(COUNTIFS($A$2:$A$8,F2,$B$2:$B$8,"生日宴")=0,"",COUNTIFS($A$2:$A$8,F2,$B$2:$B$8,"生日宴"))
4. 生日宴金额:=SUMIFS($C$2:$C$8,$A$2:$A$8,F2,$B$2:$B$8,"生日宴")
公式结果如下图示: