A B C D E F
've 2
've 1
Ew 3
Ew 4
Er 6
Er 5
Rt 4
Rt 3

How to put A column of the same item, the sum of the data in column B counterparts in column E, and A column value is also reflected in colleague's D? As follows:

A B C D E F
've 2've 3
've 1 ew 7
Ew 3 er 11
Ew 4 rt 7
Er 6
Er 5
Rt 4
Rt 3

CodePudding user response:

With advanced screening to heavy first

Then use SUMIF summation function classification

CodePudding user response:

Thank you, that if I want to compare A column data in column B and D are listed in column E is the data has been, if not always change the background, need to how to achieve?

CodePudding user response:

The first problem, with a pull out pivot table

Second, the conditional formatting