同时按Alt和F11进入宏界面,点菜单的插入,模块,粘贴如下代码:Function sumcolor(rng1 As Range, rng2 As Range) As SingleDim cell As RangeFor Each cell In rng1If cell.interior.Color = rng2.interior.Color Then sumcolor = sumcolor + cellNext cellEnd Function回到Excel中,输入 =sumcolor(C3:E7,D4),其中C3:E7是待求和的单元格区域,D4单元格有填充颜色,这两个都可以改的。如果不是填充颜色,而是字体颜色...