CODEWITHSUNDEEP
excelconditional-statementscountif
JVA
JVA

Reputation: 131

Count if with Multiple Criterias

My table has 2 columns:

Inside the seller column, we have names like Juan, Pedro, Miguel. I want to count the number of NEW cars that Juan and Pedro have sold.

I know it should be with a COUNTIFS function but haven't been able to build it.

Could someone help me with this, please?

Thanks

Upvotes: 0

Views: 43

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

wrap in SUMPRODUCT:

=SUMPRODUCT(COUNTIFS(A:A,{"Juan","Pedro"},B:B,"New"))

Upvotes: 1

Related Questions