May 22 2019 12:49 PM
Hi All,
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!
-O
May 22 2019 01:16 PM
Create a pivot table.
Country in rows area.
Status in rows area (or columns area) and in value area.
May 22 2019 01:29 PM
May 22 2019 01:59 PM
Hi All,
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.
COUNTRY | STATUS |
BE | Issued |
CH | Allowed |
CH | Issued |
DE | Issued |
EP | Issued |
JM | Pending |
ES | Issued |
May 22 2019 02:37 PM
@O_edwardsKPPB-9 , for this simple model
you may build PivotTable (to the right) with couple of clicks.
For the formula you first to build the list of all countries and list of all issues (left column and top row in the range at bottom), after that in top left column
=COUNTIFS($A$2:$A$8,$D11,$B$2:$B$8,E$10)
and drag it down and to the right.