Count Distinct Values only if Separate Column is not Blank
Fairly beginner here. I've searched multiple phrases in a search engine, looked at a dozen+ sites, and searched through this subreddit, to no avail, so I think I must be either misunderstanding what I'm reading, or not using the right magic words. Getting muddled between COUNTA, COUNTA, IFS, UNIQUE, FILTER, and various combinations thereof.
I do have it in a named table, and know how to input that. Example: tblName[ColumnName]
Column A: dates (MM/DD/YYYY). Some are blank; some are dates, some dates are duplicates.
Column B: Regions. None are blank, but there are duplicates.
I need to count the distinct (I think) number of Regions in Column B, only if Column A includes any date.
| A | B |
|---|---|
| Date | Region |
| 03/10/2026 | Region1 |
| Region1 | |
| 03/10/2026 | Region1 |
| 03/10/2026 | Region2 |
| Region3 | |
| 03/09/2026 | Region2 |
The right answer is that there are 2 regions. I don't need them listed, I just need to count them.
Thank you so very much.
EDIT for Additional Info:
I've figured out how to count the number of entries with dates: COUNTIF(tblName[Date],"<>"&"")
I've also figured out how to count the total number of region entries with dates: COUNTIFS(tblName[Date],"<>"&"",tblName[Region],"<>"&""), but can't put the two together.
[link] [comments]
Want to read more?
Check out the full article on the original site