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…
|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!