How to calculate five number summary across an array

I'm having trouble figuring out how to calculate the five number summary (min, Q1, Q2, Q3, max) with my data set. My data is set up like this:

Column A, Column B

China, 1 (China in Column A, 1 in column B)
Argentina, 1
Canada, 3
China, 4
Argentina, 6
Canada, 8
China, 10
Argentina, 5
Canada, 11

The formula for min that doesn't work is =if(A:A="Argentina,Min(B:B)). Q1 through Max I tried to do in a similar fashion. Any ideas on how to write the formulas so that it only calculates the five number summary across a range of values that meet the specific country parameter?

Thanks for your help! And hello from boiling AZ.

Attach a sample workbook mocking up what you expect as your result.

Go Advanced -> Manage Attachments -> Upload

I don't see your excel version (profile - Windows7 is not a version of Office)
but maybe you are allowed to use PowerQuery

is that what you want?

Ctry	no		Ctry	Min	Max
China	1		China	1	10
Argentina	1		Argentina	1	6
Canada	3		Canada	3	11
China	4
Argentina	6
Canada	8
China	10
Argentina	5
Canada	11