Excel 根据颜色求和，计数

通过汇总表格的背景色或者进行计数分析。

1、 首先我们要按ALT +F11键，进入VBE,然后插入模块，如下图。?

2、 在新建的模块中粘贴上代码：?Function Color_sum(rng As Range, rng2 As Range, n As Integer)?"n = 1 表示进行加总，n=0 表示 计数?Application.Volatile?Dim Ra As Range?Dim myColor As Double?Dim mySum As Double?Dim myCount As Double?myColor = rng2.Interior.ColorIndex?For Each Ra In rng?If Ra.Interior.ColorIndex = myColor Then?If n = 1 Then?mySum = Ra + mySum?End If?If n = 0 Then?mySum = mySum + 1?End If?End If?Next?Color_sum = mySum?End Function