CODEWITHSUNDEEP
google-sheets
MasonAlt
MasonAlt

Reputation: 369

Multiple criteria on a SUMIF in google spreadsheet

I am trying to see how many pounds of meat that I create, I consume.

So I have 3 columns... A: Pounds Sold, B: Customer, C: Batch

I want to see how many pounds of meat from batch "A" have been consumed by customer: EMPLOYEE.

I know how to use SUMIF but as far as I have tried I can only have 3 arguments.

Edit:

I figured out how to do this while creating a SUMIF. A SUMIFS popped up and told me that I can do multiple criteria!

Upvotes: 1

Views: 1259

Answers (1)

MasonAlt
MasonAlt

Reputation: 369

I figured out there is a SUMIFS which is the same thing as a SUMIF but in different order and has multiple criteria.

Upvotes: 1

Related Questions