ããA2æ¯èµ·å§æ°å¼3ï¼B2æ¯éå¢æ¬¡æ°4ï¼å¯ä»¥æ¹ï¼ï¼C2æ¯3åæ¯æ¬¡éå¢æ°åçåï¼é»è²é¨åæ¯æ¯æ¬¡éå¢çæ°ï¼A7æ¯A2:A6ä¹å°±æ¯3.5.7.9.11çåï¼ç¨æ¥éªè¯C2çå
¬å¼ã
ãã=MMULT(N(ROW(INDIRECT("1:"&B2+1))<=TRANSPOSE(ROW(INDIRECT("1:"&B2+1)))),A2+(ROW(INDIRECT("1:"&B2+1))-1)*2)
ããå ¬å¼ä¸ºæ°ç»å ¬å¼ï¼ä¸é®ç»æï¼ç¼è¾å®æåï¼æCtrl+shift+enterï¼
ããçXå ¬å¼å±ç¤ºå®æ¯ï¼æ¥ä¸ªæ£å¸¸ç¹ç=A2*(B2+1)+(B2+1)*B2
ããçå·®åºåån项æ±åå ¬å¼Sn=n*a1+n*(n-1)d/2ï¼a1å°±æ¯é¦é¡¹ï¼3ï¼ï¼n为æ»é¡¹æ°ï¼5ï¼éå¢äº4次å ä¸é¦é¡¹3ï¼ä¸å ±5个ï¼ï¼dä¸ºå ¬å·®ï¼2ï¼ã
公式我知道了,具体公式能不能给我解释下,谢谢了
追答就是列号除5的余数为2的列相加