CodePudding user response:

Refer to Excel the sum function,

CodePudding user response:

Use VBA code, to deal with this don't have any difficulty,

CodePudding user response:

A function, according to the cell background color, the cell text, such as, and then sum,