Excel公式哪里错了?

2025-06-28 23:52:49
推荐回答(1个)
回答1:

公式修改如下:
=SUM(SUMIFS($G$5:$G$412,$B$5:$B$412,D419,$Q$5:$Q$412,{"已开业","空铺","装修中"}))