Count if with Multiple Criterias

Question

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

Scott Craner · Accepted Answer · 2020-12-10 15:21:58Z

0

wrap in SUMPRODUCT:

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

answered Dec 10, 2020 at 15:21

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

@JVA if it worked for you, please mark as correct by clicking the check mark by the answer.

What if I would have now another column ( age of the car ) and I need to count only the ones that are equal or greater than 1990?

just add ,C:C,">=1990"