+ Reply to Thread
Results 1 to 3 of 3

Scan cells, locate a certain text and add the adjacent cell

  1. #1
    Registered User
    Join Date
    01-30-2012
    Location
    D.C.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Smile Scan cells, locate a certain text and add the adjacent cell

    Hi everyone!

    First of all, a big standing ovation to all the contributors of this forum. I have been learning new things from the old posts whenever I've needed help with excel. Thank you.

    I have been scanning the forum for hours and I can't seem to pinpoint a formula which will do the following trick for me. Please, have a look in the added excel file.

    I need a formula in cell F2 that will scan E13:E54 to find cells that contain the same string as cell D2, and then add the value from the adjacent cell. In another words, I want to find out how many total hours have been staffed in the name of DR during the month of July.

    I appreciate all the help, thank you beforehand!
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Scan cells, locate a certain text and add the adjacent cell

    hi randomintel, welcome to the forum. you mean something like this?
    =SUMIF(E$13:E$54,$D2,F$13:F$54)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    01-30-2012
    Location
    D.C.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up Re: Scan cells, locate a certain text and add the adjacent cell

    Perfect, ok so I realized my mistake. I thought I had to use LEN and that SUMIF wouldn't do the job. Great, thank you so much!

+ 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