- Registration date
- Tuesday March 7, 2017
- Last seen
- September 20, 2020
You need to use conditional formatting (SUMIF function) to correct the issue. In B7 enter:
You can see this Excel tip to learn more about the function.