
CodePudding user response:
Do not recommend using EXCEL implementation, it is suggested that the import of data to a database, and then to implement SQL query conditions can be very simple!CodePudding user response:
With an auxiliary column, the IF function, every accords with a condition of 0, is not in conformity with the conditions of 1, then SUMIF names summation, 0 is eligible=the if (or (A2=10, A2=11), 0, 1)