ä¸å¿
ç£å¤´ï¼ï¼ï¼
ALT+F11 æå
¥æ¨¡å
Function sumcol(rng As Range, icel As Range) As Single
Dim cel As Range
sumcol = 0
For Each cel In rng
If cel.Font.ColorIndex = icel.Font.ColorIndex Then
sumcol = sumcol + cel.Value
End If
Next
End Function
ç¸åé¢è²åå
æ ¼æ°æ®æ±å
å¨éè¦æ±åçåå
æ ¼éè¾å
¥ =SUMCOL(A1:A6,A1)
表示æ±A1ï¼A6ï¼åå
æ ¼å¡«å
é¢è²æ°æ®ä¹åï¼åé¢çA1ï¼è¡¨ç¤ºå¡«å
é¢è²åå
æ ¼ï¼æ ¹æ®å®é
æ
åµä¿®æ¹å³å¯ã
追é®æ说çä¸æ¸
æ¥,è¡¨æ ¼ä¸å¡«å
é¢è²,åªæ¯æ°åæé¢è²,èä¸æ¯å¥½å¤æ°,è¿æä¹æ±å,å¦æè¾å
¥A1ï¼A6,ä¸é´æä¸åçé¢è²ä¹å äº,é£ä¸ç®éäºå,èä¸æ°åå¾å¤ï¼å¦ææ¯æ¬¡é½å段设çè¯,ç´¯æ»äº,æ¯å¦æ¨ªè¡120è¡,ç«å20å,æä¹å¼å
追çä½ å
è¯ä¸ï¼æåªæ¯ä¸¾ä¾