Counting Distinct values, number and text

GWHotmail 

I'm going to have to beg your patience here. At present I'm away from my home base, where I have two screens to work with, each quite a bit larger than the screen on my laptop. And tackling your issue is going to require me to take full advantage of the larger real estate on those two screens. Perhaps somebody else can hop in in the meantime. I expect to be at home toward the end of the day today.

Also in the meantime, if I might: In your very first post you wrote:

I'm using MS Excel 2016 professional, but it needs to run on 2013.

I can calculate the "Course" data easy enough, but I CANNOT figure out how to do this for "Members". There's multiple categories that each could be counted in. I've tried using versions of UNIQUE, FREQUENCY, COUNTIF, etc

And there are at least two things there that concern me with regard to the assistance you're seeking.

1. First, your statement that "it needs to run on 2013" suggests that you're creating a sheet that will be used by others (which underscores the necessity for clear design, first of all) on older versions of Excel, and
2. Second, THAT means they won't have access to functions like UNIQUE or FILTER, which are only available in the most recent releases. That kind of puts some limitations on the solutions that are possible.

On a more positive note, it does occur to me that some very old and less frequently used functions might serve your purpose. So you might want to poke around in them while you wait. And if indeed we must create a solution that works with Excel 2013, this may be the most workable solution. Excel has had for at least a couple of decades a set of Database functions. They're the ones that begin with the letter D, and include such things as DSUM, DGET, DAVERAGE, DCOUNT....  There's a bit of a learning curve to mastering them, but they provide the kind of data extraction that you appear to be seeking. DCOUNT in particular. I've never used it, but I have used (in fact am using currently) DGET in a personal budget and expense tracking sheet. I've used DSUM recently in an invoicing system I created for my wife's consulting, yielding different figures for work done during any given month in each of a number of project categories, extracting that data from a table she maintained to record hours worked on each project by date.

Here's a link to a website that might point you toward how you could use those database functions and solve this on your own.

https://exceljet.net/search?query=database

I will say that the trickiest part for what you're trying to do may be figuring out a way to array the criteria so that the DCOUNT results get displayed in the table(s) where you want them. But I do think it could work.

It might be that Power Query could address your concerns--but that is a capability that others will have to address as I've not delved into its intricacies.