本帖最后由 xuyouxm 于 2014-4-8 17:59 编辑
- =IF(C2=2,SUMPRODUCT(($G$2:$G$17=A2)*($I$2:$I$17)*($H$2:$H$17={12,1,2})),IF(C2=3,SUMPRODUCT(($G$2:$G$17=A2)*($I$2:$I$17)*($H$2:$H$17={3,1,2})),IF(C2=1,SUMPRODUCT(($G$2:$G$17=A2)*($I$2:$I$17)*($H$2:$H$17={11,12,1})))))
复制代码 试试,不知对不对!- =IF(C2=2,SUM(($H$2:$H$17=A2)*($J$2:$J$17)*($I$2:$I$17={12,1,2})),IF(C2=3,SUM(($H$2:$H$17=A2)*($J$2:$J$17)*($I$2:$I$17={3,1,2})),IF(C2=1,SUM(($H$2:$H$17=A2)*($J$2:$J$17)*($I$2:$I$17={11,12,1})))))
复制代码 |