With data in A1:B1000, company name in D1, country name in E1

=SUMPRODUCT((A1:A1000=D1)*(B1:B1000=E1)) in C1

Alan Beban

Dimmer wrote:
Hi everyone

I have two columns with non-numerical data that is repeating over 100 rows
(soon we're going to get over 1,000 new observations):

1. Company Name: Fedex, DHL, UPS
2. Country: US, Germany, Belgium etc....

I would like to know for example how many packages sent with Fedex are going
to US, Germany etc.
Of course this can be done with filtering the first column by Company Name
(ex: FedEx), and then counting all the US (second filter), Germany etc........

... but can I do it in any way with a formula (any double COUNTIF)?

Thanks!