- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-2-26 16:30 ½s¿è
¦^´_ 12# handmuch
¯Å¶Zªíªº¤è¦¡¨Ó¼g¤½¦¡¡A¥»¨Ò°â¥XÁ`»ù¥i¨Ï¥ÎLOOKUP¨ç¼Æ©Î³\§ó®e©ö²z¸Ñ
B1=IF(A1>0,SUMPRODUCT(LOOKUP(ROW(INDIRECT("A1:A"&A1)),{0,13,41},{1080,970,700})*1),"")
B2°}¦C¤½¦¡
=IF((A2>0)*(A2<=A1),SUM(SMALL(LOOKUP(ROW(INDIRECT("A1:A"&A1)),{0,13,41},{1080,970,700}),ROW(INDIRECT("A1:A"&A2)))),"") |
|