import pandas as pd SD = pd.read_excel ('SampleData (3).xlsx') CentralBinder = SD[(SD.Region == 'Central') & (SD.Item == 'Binder')] print(CentralBinder.Units.sum())