![](https://img.codepudding.com/202009/94386220848411.png)
CodePudding user response:
Refer to Excel the sum function,CodePudding user response:
Use VBA code, to deal with this don't have any difficulty,![](https://img.codepudding.com/202009/94386220848412.gif)
CodePudding user response:
A function, according to the cell background color, the cell text, such as, and then sum,