+ Reply to Thread
Results 1 to 4 of 4

Search Column text and add the numeric values of each hit from another Column

  1. #1
    Registered User
    Join Date
    02-17-2020
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Office 365
    Posts
    2

    Search Column text and add the numeric values of each hit from another Column

    I would like to search a Column range for specific text. Then for each match I would like to have a total derived from the numeric value in another Column from the same row.

    For instance: If D5 returned true then get the value of C5 and if D8 returned true add the value of C8 to it for a running total and so on.

    "Thank You in Advance" = True!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Search Column text and add the numeric values of each hit from another Column

    Hello mslabb. Welcome to the forum.

    Have you tried using SUMIF(s)?
    Dave

  3. #3
    Registered User
    Join Date
    02-17-2020
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Search Column text and add the numeric values of each hit from another Column

    Thank you FlameRetired for the welcome and the solution!

    That works exactly for what I needed to do.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Search Column text and add the numeric values of each hit from another Column

    You are welcome. Glad to help. Thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 07-26-2017, 05:11 AM
  2. [SOLVED] Grab numeric values from column B to Column C
    By YasserKhalil in forum Excel General
    Replies: 5
    Last Post: 10-03-2016, 12:15 PM
  3. Replies: 9
    Last Post: 11-18-2013, 07:40 AM
  4. [SOLVED] Help find MAX value in one column when numeric & alph-numeric values are present
    By KevinAB in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2013, 11:29 AM
  5. Replies: 1
    Last Post: 07-26-2011, 06:48 AM
  6. Sum column that contains both numeric and text values
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2010, 09:33 PM
  7. Formatting Text based on numeric values in the next column
    By Grateful in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2009, 11:10 AM

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