How to find and extract values in a range

Hi, I have a huge worksheet with over 5000 rows of customers, and I need to do all sorts of analyzing. I am now stuck with one thing and that is to analyze the data of the current customers, excluding the customers that are not active. The way to find out that a customer is active is to look at column H. If the last date shown for each customer is after today's date, it's active. If not, I need to exclude them in the analysis. Example: customers 23 and 32 are inactive. For instance, how do I count the active customers and sum up the premium in column C for only the active customers? I have attached the file.

I appreciate the help !

Thanks, but I also want to include all the data for each relevant customer including the data that's before today's date. Example: customer 5 has 9 entries and 450 in premium. But I want to exclude all the data for customers 23 and 32.

Thanks for your help! Although it didn't exactly did what I needed, it helped me to work around the problem and come up with a solution.

I couldn't have done it without your help !