I have an Excel spreadsheet with the following:
Column G: Submit Date Aging (how many days old an item is)
Column K: Assigned Group (roughly about 25 different groups)
I have a total of 4 colums that I need help with:
Column T: 1-4 Days Old
Column U: 5-13 Days Old
Column V: 14-29 Days Old
Column W: 30+ Days Old
Need to seach column K for a particular Assigned Group, search column G for the Submit Date Aging against column K then add the numbers to the cells in column T, U, V and W.
For example, row 2, column T (cell T2) will be the total number of items that are 1-4 Days Old for one particular Assigned Group. Row 3, column T (cell T3) will be the total number of items that are 1-4 Days Old for a different particular Assigned Group. And so forth.
Thank you,
Keith
Bookmarks