- 孟想用户2024-11-22[[{"txt": "\u9047\u5230\u8981\u628a\u51e0\u767e\u4e2a\u7535\u8bdd\u53f7\u7801\u5feb\u901f\u8bc6\u522b\u51fa\u662f\u79fb\u52a8\uff0c\u8054\u901a\uff0c\u8fd8\u662f\u7535\u4fe1\uff0c\u4e00\u4e2a\u4e00\u4e2a\u6253\uff0c\u7d2f\u6b7b\u4e86\uff0c\u4f30\u8ba1\u5f97\u597d\u51e0\u4e2a\u5c0f\u65f6\u7528\u5728\u8fd9\u4e0a\u9762\u4e86\uff0c\u773c\u775b\u90fd\u770b\u9178\u4e86\uff0c\u4e0b\u9762\u7684\u65b9\u6cd5\u53ef\u4ee5Excel\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u9996\u5148\u5efa\u4e00\u4e2a\u8f85\u52a9\u5355\u5143\u683c\uff0c\u586b\u4e0a\u5404\u8fd0\u8425\u5546\u7684\u53f7\u6bb5\uff0c\u5982\u4e0b\u56fe"}, {"img": ["https://exp-picture.cdn.bcebos.com/e2aefe781431dfb6279ec9d512cf02532e636345.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u8fd0\u8425\u5546\u4e0b\u9762B2\u5355\u5143\u683c\u8f93\u5165=INDEX(G1:I1,SUM(IF(LEFT(A2,3)-G2:I23,,COLUMN(A:C))))\u8f93\u5b8c\u540e\u6ce8\u610f\uff1a\u9009\u4e2dG1:I1\u548cG2:I23\uff0c\u6309F4\u7edd\u5bf9\u5f15\u7528\uff0c\u5c31\u53d8\u6210\u8fd9\u6837\u7684=INDEX($G$1:$I$1,SUM(IF(LEFT(A2,3)-$G$2:$I$23,,COLUMN(A:C))))"}, {"img": ["https://exp-picture.cdn.bcebos.com/486884883913e8e5171c330f352f477047187d4a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u540c\u65f6\u6309\u4e0bCtrl+shift+enter\uff0c\u6700\u540e\u53cc\u51fb\u586b\u5145\u67c4\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/49bf00425d6b04d1bed8043bb213e8e5edee0145.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/ef4c24ceaad7726b3311fb54bf0f64781523b94a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]1楼