I have an excel workbook with many client account names (column A in example image). There is a column B, which is irrelevant to this, but is the reason that client names are repeated.
I need to then, in another workbook with just one entry for each client name, sum the number of times that the client name appears as true (1) in column C of the original workbook. The cells with blue headers in the example image illustrate the 2nd workbook with just one entry for each account name. This formula is important, as I have a very large number of clients, and need to perform this same statistic for a number of different criteria.
I am trying to do something along the lines of count the number of successful VLookups. I have now gone this direction, for the data shown in the example image:
The above formula would appear in cell H2. In the real workbooks, the cells with yellow headers and blue headers are in separate workbooks.