import pandas as pd df = pd.read_excel('/tmp/tmptv74cpdk.xlsx') food_sales = df[df['Category'] != 'Drinks']['Sales'].sum() print(food_sales)