制令单日期制令单号品号0111200110111200110122100150122100150122100150111200020111200022021-03-30MO133000312021-04-222021-04-132021-05-102021-05-202021-05-202021-05-31MO14220007MO14130038MO15100011MO15200012MO15200011MO15310015分类AAAAAAA工单计200240300030003000120240单价108金额21600订单数169库存数1411411925192519252525在制数量18018000000备货数量152152-2667-2667-2667-21-21欠货数量-28-28-2667-2667-2667-21-2110825920169100390000459210030000045921003000004592981176046982352046问题：C列品号有重复品号数公式计算L，O列不重复数已完成工单欠数数欠货金额分类2000-3024A18060-302430000-26670003000-26670003000-2667000120-20580240-2058MATCH函数精确匹配是会从上向下查找，只会返回符合条件的数据第一次出现的相对位置欠货数量欠货金额-2716-271782-2716-27161TRUE1FALSE3TRUE3FALSE3FALSE6TRUE6FALSE1133366
复品号，如何用函重复数据求和。
