[RANGE = rs:14 | cs:4 | w:取数求助.xlsm | cls:xl2bb-128 | s:Sheet2 | tw:392] [XR] [XH] [/ XH] [XH = w:106] A [/ XH] [XH = w:90] B [/ XH] [XH = w:93] C [/ XH] [XH = w:103] D [/ XH] [/ XR] [XR] [XH ] 1 [/ XH] [XD = h:l | v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww]到期日[/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Product [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb bbw] Quantity [/ XD] [XD = h: l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Priority [/ XD] [/ XR] [XR] [XH] 2 [/ XH] [XD = v:m | bc:FEFEFE | ch :17.25 | cls:bl bt br bb ww] 30/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Apple [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:22000] 22,000.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt bb bb ww] [FORMULA =' {= SUM(-(A2 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B2,ROW($ 2:$ 14)-1), 4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B2))))))))))))))))))))))))))))]] 2 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 3 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww] 20/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb bb ww] Orange [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:4800] 4,800.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM(- -(A3 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B3,ROW($ 2:$ 14)-1,4 ^ 8), ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B3))))))))))))))))))))))))))))})))}))})}]] [] 2 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 4 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww] 15/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww]橙色[/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:7155] 7,155.00 [/ XD] [XD = v :m | bc:FEFEFE | cls:fx bl bt br bb bb ww] [FORMULA ='{= SUM(-(A4 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF ($ B $ 2:$ B $ 14 = B4,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B4))))) ))))+ 1}'] 3 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 5 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls: bl bt br bb ww | tx:2/10/2020] 2/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Pear [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb bb ww | tx:3800] 3,800.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt bb bb ww] [FORMULA ='{= SUM(- -(A5 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B5,ROW($ 2:$ 14)-1,4 ^ 8), ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B5))))))))))))))))))))))))))))))))})))}))}}] 3] [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 6 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww | tx:8/10/2020] 8/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Apple [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt bb bb ww] 800 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM(-(A6 <INDEX($ A $ 2:$ A $ 14,N(IF({1} ,SMALL(IF($ B $ 2:$ B $ 14 = B6,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B6) )))))))+ 1)'] 1 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 7 [/ XH] [XD = v:m | bc:FEFEFE | ch: 17.25 | cls:bl bt br bb ww] 22/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb bb ww]橙色[/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb bb ww | tx:1750] 1,750.00 [/ XD ] [XD = v:m | bc:FEFEFE | cls:fx bl bt bb bb ww] [FORMULA ='{= SUM(-(A7 <INDEX($ A $ 2:$ A $ 14,N(IF({1 },SMALL(IF($ B $ 2:$ B $ 14 = B7,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B7 )))))))))+ 1)'] 1 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 8 [/ XH] [XD = v:m | bc:FEFEFE | ch :17.25 | cls:bl bt br bb ww] 26/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb bbw] Pear [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:66250] 66,250.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt bb bb ww] [FORMULA =' {= SUM(-(A8 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B8,ROW($ 2:$ 14)-1), 4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B8)))))))))))))))))))))))))})]] 2 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 9 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb bb ww] 23/10/2020 [/ XD] [XD = h: l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Apple [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:1060] 1,060.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM(-(A9 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B9,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B9))))))))))))))))}}) '] 4 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 10 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb bb ww | tx :12/10/2020] 12/10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww]橙色[/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:5500] 5,500.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM( -(A10 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B10,ROW($ 2:$ 14)-1,4 ^ 8)) ,ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B10)))))))))))))))))))))))))))))))))))})))})]] 4] [/ FORMULA] [/ XD] [/ XR] [XR ] [XH] 11 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww] 28/10/2020 [/ XD] [XD = h:l | v: m | bc:FEFEFE | cls:bl bt br bb ww] Apple [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:3500] 3,500.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM(-(A11 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B11,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B11)))))))))))))))))+ 1) '] 3 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 12 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb ww] 27 / 10/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb bb ww] Pear [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:16000] 16,000.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb bb ww] [FORMULA ='{= SUM(-(A12 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B12,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1: $“&COUNTIF($ B $ 2:$ B $ 14,B12))))))))))))))))})))}]] 1 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 13 [/ XH ] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb bb ww] 21/11/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Banana [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:13000] 13,000.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM(-(A13 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B13,ROW($ 2:$ 14)-1,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B13))))))))))))))))+ 1) '] 1 [/ FORMULA] [/ XD] [/ XR] [XR] [XH] 14 [/ XH] [XD = v:m | bc:FEFEFE | ch:17.25 | cls:bl bt br bb bb ww | tx :11/11/2020] 11/11/2020 [/ XD] [XD = h:l | v:m | bc:FEFEFE | cls:bl bt br bb ww] Banana [/ XD] [XD = v:m | bc:FEFEFE | cls:bl bt br bb ww | tx:10873] 10,873.00 [/ XD] [XD = v:m | bc:FEFEFE | cls:fx bl bt br bb ww] [FORMULA ='{= SUM( -(A14 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B14,ROW($ 2:$ 14)-1,4 ^ 8)) ,ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B14))))))))))))))))))))))))))}))))}))))}))]] [] 2 [/ FORMULA] [/ XD] [/ XR] [/ RANGE] [RANGE = cls:xl2bb-extra-128 | t:cf | f:xtra] [XR] [XD] D2:D14 [/ XD] [XD = fw:b] D2 [/ XD] [XD = c :FF0000] = SUM(-(A2 <INDEX($ A $ 2:$ A $ 14,N(IF({1},SMALL(IF($ B $ 2:$ B $ 14 = B2,ROW($ 2:$ 14)-1) ,4 ^ 8),ROW(INDIRECT(“ $ 1:$”&COUNTIF($ B $ 2:$ B $ 14,B2)))))))))))))))+ 1 [/ XD] [/ XR] [/ RANGE]
[/引用]
好像出了点问题