2007çï¼å¯ä»¥æé¢è²çéï¼çéåç¨å
¬å¼ =SUBTOTAL(9,A1:A20000)æ¥æ±A1å°A20000ä¸çéåçåã
2003çï¼
éä¸åå
æ ¼B1ï¼ç¹èåçæå
¥ï¼å称ï¼å®ä¹ï¼å称å¤è¾å
¥ abcï¼å¼ç¨ä½ç½®å¤è¾å
¥ =GET.CELL(63,A1)
ç¡®å®ã
ç¶åå¨ä»»æåå
æ ¼çå³è¾¹ä¸æ ¼æ¯å¦B2è¾å
¥ =abcï¼å¯ä»¥å¾å°å
¶å·¦è¾¹åå
æ ¼çå¡«å
é¢è²ä»£ç ãå
¬å¼å¤å¶ä¸å»ï¼ç¶åç¨å½æ°SUMIF()æ±åï¼æ¯å¦ =SUMIF(B:B,6,A:A) å¯ä»¥æ±Aåé¢è²ä¸ºé»è²çåã
æ 论2003ã2007ï¼å½ç¶ä¹å¯ä»¥ç¨å®èªå®ä¹å½æ°ï¼
åæ¶æAltåF11è¿å
¥å®çé¢ï¼ç¹èåçæå
¥ï¼æ¨¡åï¼ç²è´´å¦ä¸ä»£ç ï¼
Function sumcolor(rng1 As Range, rng2 As Range) As Single
Dim cell As Range
sumcolor = 0
For Each cell In rng1
If cell.interior.Color = rng2.interior.Color Then sumcolor = sumcolor + cell
Next cell
End Function
åå°Excelä¸ï¼è¾å
¥ =sumcolor(C3:E7,D4)ï¼å
¶ä¸C3:E7æ¯å¾
æ±åçåå
æ ¼åºåï¼D4åå
æ ¼æéè¦çåä½é¢è²ï¼è¿ä¸¤ä¸ªé½å¯ä»¥æ¹çã
温馨提示:答案为网友推荐,仅供参考