As attached, there are 6 orders in the worksheet. One customer can place
more than one orders. The value in the 'Total' column for each customer
represents the SUM of V1, V2, V3 and V4. I want to check whether all values
input in V1 to V4 for each customer are summed correctly to arrive the TOTAL
value.

For example, for Cust_ID 67678, sum of the values of V1 to V4 is 4
(1+1+1+1), which match the value in TOTAL column. = Data correct.
But for Cust_ID 89789, sum of the values of V1 to V4 is 4, which does not
equal 3 - the value in TOTAL colum. = Data incorrect.

I have no idea....
Can excel solve this?
Many Thanks!!