data sets deletion where sum is below 500

[meetvivek72]

Hi,
i m facing some problem in excel data workbook 2007, Actually as in the attachment there are many data sets, and the sum of Column E of every data set is shown in yellow. Thus i need only those data sets to be included in my sheet where sum is > 500 (above 500) . Rest of the data sets where sum is less than 500 should be deleted from there.

1089 - 1259 171 171
1347 - 1412 66 66
1499 - 1579 81 81
1670 - 1750 81 81
SUM 399

13827 - 14108 282 282
14497 - 14583 87 87
14653 - 14766 114 114
14864 - 15064 201 201
15169 - 15291 123 123
15420 - 15659 240 240
SUM 1047

376 - 480 105 105
709 - 819 111 111
1088 - 1240 153 153
SUM 369

2109 - 2261 153 153
2313 - 2618 306 306
SUM 459

5313 - 5501 189 189
SUM 189

1920 - 3002 1083 1083
SUM 1083

 

[Sektor]

What is namely in cell with sum? Word "Sum"?

 

[meetvivek72]

see SUM is the total sum (addition of all cells in last column ,actually i m unable to attach test sheet here). I need only those sets to be included in this workbook whose SUM is greater than 500 (rest i.e, <500 should be deleted from this workbook)..

 

[Sektor]

Send sample sektor81@mail.ru

 

[Peter_SSs]

Send sample sektor81@mail.ru

Please keep in mind #7 of the Forum Rules

 

[Sektor]

I ain't gonna guess user's file structure that's why I ask sending it to e-mail. It's not my fault that users can't attach files in this forum.