I have a sheet with 2 columns, one for Country and one to represent a status, either status A or status B. I would like to have a formula that can sort through and give me the number of A statuses and the number of B statuses per country. So far, I have been unable to come up with anything. Any ideas?
Thanks for the replies. I am having some issues with the Countif function. Attached below is an example of a chart we get (though they are usually about 200 rows!). Would the countif function be able to tell me BE has 1 issues, CH has 1 allowed and 1 issued, etc.