+ Reply to Thread
Results 1 to 2 of 2

Need assistance with a formula

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    Rochester Hills, MI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need assistance with a formula

    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

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need assistance with a formula

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1