COUNTA for Indexed cells without solving for the index

My title may be a bit ambiguous. I'm going to try and explain this as thorougly as possible but it is a bit difficult to describe with confidential information. I have about 3000 records so I'll try to make a simple example:

I have a column "Direct to Branch" and then I also a column for "Client." Under "Direct to Branch," I have option A, B, or C and this is for all of the data. However, I need to solve for the amount of As, Bs, Cs and the total when I filter by client. I would not normally have an issue if I could keep the data filtered but I need to do the same thing for every client so I'm trying to do this process without filtering.

so far, I have the equation (for the count of all As, Bs, and Cs):

=COUNTA(INDEX('DIRECT TO BRANCH'!A1:A100, MATCH ("CLIENT NAME", 'CLIENT'!B1:B100,0)))

but it is only giving the number 1 as a result because it is only one index. Any help or if I can provide a better description, please let me know. Thank you!

Scott B.

yeah let me try to make one really quick

I was actually just looking at that. I've never used COUNTIFS before; I've only used COUNTIF. I'll make a sample spreadsheet to see if that works or not.

COUNTIFS worked for a specific branch to be directed to. How would I count the total for a specific client without filtering?

I attached a spreadsheet which is quite bare bones of what I'm working on.

And in response to the pivot tables comment, my company is actually using them and everything, but they wanted me to fix these equations so I can present percentages so that an Average Joe could understand what the data means. I completely agree though.

Well the problem with what I'm working on is it gets a little more complicated. I'm going to attach a different spreadsheet that is a little more complex because there is another column involved and the "Direct to Branch" column values depend on it. I'll post it in a minute

Okay so to provide a little bit about what's going on now, I changed the previous branch "C" to blank because that is what it's like on this spreadsheet I'm working on. However, I do not want to have =COUNTIFS (C:C, "", D:D,"Client 1") because that would count all of the blanks when really every order should not be counted. Only the transfers should be counted but I also want to count the pending ones because they will be transferred at some point, but they also have a blank for the final allocation. Does that sort of make sense?

It's getting closer. However the only problem I have is that the spreadsheet I'm working with doesn't say PENDING. Imagine it as a description box but meaning the same thing. The issue with this is that all of the descriptions are different. But, if there is a description, then it is pending. Does this make sense?

Okay I'll have to give that a whirl because that seems to be the most functional way of doing things right now. Thanks a bunch!

Okay I have another question for you though: this puts an X for files that do not even need a transfer (basing it off of my example spreadsheet) so that the Xs are shown for files that do not even need a transfer plus the files that are pending. Then when calculating that it shows more files than it should. So is there a way to express if B:B has text but C:C is "", then to put an x in column E? Is that possible?

Oh I think I figured it out, I did =IF(B:B="", "", "x") so that will show all transfers. I think that's what you said in the first place. Thanks again for all of your help today!