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 !
Bookmarks