æç §é¢ç®è¦æ±ï¼è¯·å¨A3è¾å ¥å ¬å¼ï¼
=IF(SUM(A2)>=1000-COUNTIF(A$2:A2,1)+1,1,SUM(A2)+1)
ä¸æå³å¯
ç±äº1000太大ï¼æ使ç¨ååçåæ°è¿è¡æ¼ç¤ºï¼é¦æ¬¡å¾ªç¯èå´æ°å¼å¡«å¨B2éé¢ï¼å ¬å¼æ¹ä¸ºï¼
=IF(SUM(A2)>=$B$2-COUNTIF(A$2:A2,1)+1,1,SUM(A2)+1)
è¿æ ·B2è¾å ¥5çæ¶åå ¬å¼ç»æå¦ä¸ï¼
B2ä¿®æ¹ä¸º6åç»æå¦ä¸ï¼