So, what I need feels a bit complicated, but maybe I’m overlooking something. I have a multipage sheet tracking members. I have it broken down my state and what category of member they fall into. So our main sheet has all of that info and then the category types are linked to another separate table and then there’s another linked column with state that has it’s own table. So I know I can pull the states that are associated with the different categories and vice versa, and even get a count of how many members are in the various states or different categories, but what I’d like to see is a count of how many of each category type are in each state. For example, I want to see how many of our sponsors are in NY, WY, NC, etc.
Is that possible?
I tried count formulas to count how many times NY appears for each category type, but I can’t seem to figure it out so it counts the number of times the state value appears from a linked table or lookup column.