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!