Results 1 to 5 of 5

Thread: Formula Help

  1. #1

    Formula Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi There

    I need a formula that is going to pull data from two seperate raw data sheets, the formula needs to do the following:


    • recognise a persons name
    • recognise the date
    • count the amount of cells that show a persons name against a specific date and multiply by 10 on one sheet and then add that to a total figure assigned in another sheet against the same name and date


    Any help would be appreciated

    Thanks

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    can you please upload a workbook with dummy information, that has the format of what you are trying to do.
    a short answer would be use a countif()

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    if you have your list of names in column A, and dates in column B.
    =COUNTIFS(A1:A??,"="&??,B1:B??,"="&??)
    replace the ?? with the ending ranges, or the name/date you want to check against.

    hope this gets you going.

  4. #4

    reply with attachment

    Quote Originally Posted by Simi View Post
    can you please upload a workbook with dummy information, that has the format of what you are trying to do.
    a short answer would be use a countif()
    I have attached a spreadsheet in the first tab ignore actual worked column (column G)

    Thanks for the help

  5. #5
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    I'm sorry but I don't see the attachment. You need to click the "Go Advanced" button to attach a spreadsheet.

Posting Permissions

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