在sql中，可以执行以下操作：

SELECT *
FROM table_name
WHERE customer_id = 123667
    AND sales365D >= 0

或者在python中，您可以使用pandas库导入并按如下方式进行过滤：

import pandas as pd

df = pd.from_excel('filename.xlsx')
df = df[(df.customer_id == 123667) & (df.sales365D >= 0)].copy()
df.to_excel('filename_w_no_errors.xlsx')

您可以使用以下技巧：

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    add = Table.AddColumn(Source, "Abs", each Number.Abs([Sales])),
    group = Table.Group(add, {"Customer ID", "Abs"}, {{"sum", each List.Sum([Sales])},
                                                    {"all", each Table.RemoveColumns(_, "Abs")}}),
    filter = Table.SelectRows(group, each ([sum] <> 0)),
    final = Table.Combine(filter[all])
in
    final