This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a table with a bunch of loan accounts in column A and the data related to those loan accounts in the following columns, one of them being "# of days past due" which include the exact number of days that account is passed due. I want to group the loans together based on a range of days past due (1-30,31-60,61-90,and 90+) and pull the related data into those groups including a count of how many loans fall into that pool, the sum of the past due amount, and the sum of the principle balance for the loans in each days past due group.