Trying to count how many “valid” (i.e., non-missing) cases I have, but based on the criteria from another column. For example, with this data…
|
A |
B |
C |
| 1 |
Vietnam |
Asia |
45 |
| 2 |
Yemen |
Asia |
|
| 3 |
Belize |
Central America |
70 |
| 4 |
Costa Rica |
Central America |
9 |
| 5 |
El Salvador |
Central America |
|
I’d like to be able to tell that 1 country in Asia (i.e., Vietnam) has data for column C, while 2 countries in Central America (i.e., Belize and Costa Rica) do. I presume I’d need two separate functions (one for Asia, one for Central America).
Typically I use COUNTIFS when I’m trying to count how often something appears (e.g., =COUNTIFS(B2:B5, “Asia”) would be 2). Or, I use COUNTBLANK if I’m interested in how much data is missing (e.g., =COUNTBLANK (C1:C5) would also be 2).
But, I’d like to know how many things in column C meet criteria from column B. I’ve used functions in LibreOffice for years, but apparently have never had to do something like this before, and I’m a bit stumped. Any help would be greatly appreciated!
