1、IF($A4="总计",SUM(OFFSET(E$4,0,0,ROW()-4,1)),IF(A4="","",IF(ISERROR(GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4,"费用项目2","商品销售收入")),0,GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4,"费用项目2","商品销售收入"))));
2、IF($A4="总计",SUM(OFFSET(F$4,0,0,ROW()-4,1)),IF(A4="","",IF(ISERROR(E4-VLOOKUP(A4,销售成本透视!I:L,4,0)),0,(E4-VLOOKUP(A4,销售成本透视!I:L,4,0)))))
3、IF(A4="总计",GETPIVOTDATA("求和项:zk",销售成本透视!$H$3,"经销商名称",单店分析!$Q$2),IF(ISERROR(VLOOKUP(A4,销售成本透视!I:M,5,0)),0,VLOOKUP(A4,销售成本透视!I:M,5,0)))
4、IF($A4="总计",SUM(OFFSET(J$4,0,0,ROW()-4,1)),IF(A4="","",IF(ISERROR(GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4,"费用项目2","租赁费")),0,GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4,"费用项目2","租赁费"))))
5、IF($A4="总计",SUM(OFFSET(L$4,0,0,ROW()-4,1)),IF(A4="","",IF(ISERROR(GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4)-E4),0,GETPIVOTDATA("13",收入费用透视!$A$4,"店仓名称",A4)-E4)))
6、IF($A4="总计",SUM(OFFSET(M$4,0,0,ROW()-4,1)),IF(A4="","",F4-L4))
这几个函数啥意思,请朋友帮忙解释一下,谢谢! |