I have a table that contains a client name, target performance metrics and actual performance metric over the course of a year. Each client has multiple performance metrics which get monitored and each metric has a different target performance rate.
I'm trying to create a summary view of how many performance metrics have been met for each client. I'm currently doing this by adding a bunch of countif statements, but having to create so many statements is very time consuming and if I add a client I need to completely recreate the formulas, so I'm looking to upgrade to a formula that will work even if I add new clients or new performance metrics to an existing client.
What I need is a formula that will count the number of instances where:
Column A on the Data Driver sheet is equal to Column C on the Client Summary sheet
& Columns D:AA is greater than or equal to Column C on the Data Driver sheet
& where the date in Client Summary is equal to the date in Data Driver
Sorry, I know I'm not explaining this well! Adding a sample spreadsheet to assist.
I'm trying to create a summary view of how many performance metrics have been met for each client. I'm currently doing this by adding a bunch of countif statements, but having to create so many statements is very time consuming and if I add a client I need to completely recreate the formulas, so I'm looking to upgrade to a formula that will work even if I add new clients or new performance metrics to an existing client.
What I need is a formula that will count the number of instances where:
Column A on the Data Driver sheet is equal to Column C on the Client Summary sheet
& Columns D:AA is greater than or equal to Column C on the Data Driver sheet
& where the date in Client Summary is equal to the date in Data Driver
Sorry, I know I'm not explaining this well! Adding a sample spreadsheet to assist.