I need to verify totals for data that changes on a monthly
basis. In the sample below, the number across from each
Name represents a total recorded for that person. I need
to verify that the numbers beneath this value add up to
the recorded total.

Example: Bill's total is correct since 2+3+5=10
Mary's total is NOT correct since 4+2+1 < 6

Incorrect totals are to be formatted red

Any suggestions on what code I can use?

A B
1 Name Qty

2 Bill 10

3 2

4 3

5 5

6 Mary 6

7 4

8 2

9 1