Please HELP: Checking data
 

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!!

Please HELP: Checking data
 

One way ..

Here's the link to the sample construct:
http://cjoint.com/?meobDmg6xe
Checking Data guy_wks.xls

Put in J1, copy to M1: =SUMIF($B:$B,$B2,E:E)
Put in N1: =IF(SUM(J2:M2)=D2,"OK","Not OK")
Select J1:NI, copy down
Col N returns the results of the desired checks: "OK", or "Not OK"
(If required, just autofilter on col N to filter out "Not OK" items)

Btw, please do not post attachments *direct* to the newsgroup
Either describe / paste the sample data in plain text,
and/or use a free filehost* to upload a small sample file
& then include the link to the file in your post (like what was done above)

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

For cjoint.com (it's in French), just click "Browse" button, navigate to
folder select the file Open, then click the button centred in the page
below (labelled "Creer le lien Cjoint") and it'll generate the link. Then
copy & paste the generated link as part and parcel of your post.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"guy" wrote in message
...
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!!

Please HELP: Checking data
 

Thanks a lot!!
Sorry...next time I won't attach files.

"Max" hx.gbl...
One way ..

Here's the link to the sample construct:
http://cjoint.com/?meobDmg6xe
Checking Data guy_wks.xls

Put in J1, copy to M1: =SUMIF($B:$B,$B2,E:E)
Put in N1: =IF(SUM(J2:M2)=D2,"OK","Not OK")
Select J1:NI, copy down
Col N returns the results of the desired checks: "OK", or "Not OK"
(If required, just autofilter on col N to filter out "Not OK" items)

Btw, please do not post attachments *direct* to the newsgroup
Either describe / paste the sample data in plain text,
and/or use a free filehost* to upload a small sample file
& then include the link to the file in your post (like what was done
above)

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

For cjoint.com (it's in French), just click "Browse" button, navigate to
folder select the file Open, then click the button centred in the page
below (labelled "Creer le lien Cjoint") and it'll generate the link. Then
copy & paste the generated link as part and parcel of your post.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"guy" wrote in message
...
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!!

Please HELP: Checking data
 

You're welcome !
Thanks for feeding back ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"guy" wrote in message
...
Thanks a lot!!
Sorry...next time I won't attach files.