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

score 1 · Accepted Answer · answered Dec 10 '20 at 15:21

1

wrap in SUMPRODUCT:

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

answered Dec 10 '20 at 15:21

Scott Craner

@JVA if it worked for you, please mark as correct by clicking the check mark by the answer. – Scott Craner Dec 10 '20 at 15:34
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? – JVA Dec 10 '20 at 16:22
just add `,C:C,">=1990"` – Scott Craner Dec 10 '20 at 16:23

1 Answers1