如上表,我们要求班组为"甲(白)",产量"<>0"的F0,F1,F2,F3,F4的和。
公式:=SUM(SUMIFS(OFFSET(E:E,,{1,2,3,4,5}),B:B,"甲(白)",E:E,"<>0"))
参考链接:https://zhidao.baidu.com/question/423955275403435652.html?qbl=relate_question_1
https://zhidao.baidu.com/question/1497728456744827379.html?sort=11&rn=5&pn=0#wgt-answers