+ Reply to Thread
Results 1 to 2 of 2

Track Values in a Cell with a Neighbor Cell Containing Specific Keywords, how?

  1. #1
    Registered User
    Join Date
    03-08-2019
    Location
    Salt Lake City, UT
    MS-Off Ver
    16.9 OSX
    Posts
    1

    Track Values in a Cell with a Neighbor Cell Containing Specific Keywords, how?

    Hi all, first post here. Not quite sure how to search for this query, everything I searched for online was for SEO type keyword tracking.

    I have a budget tracker that spans years. I would like to get a summary of income and expenses at the bottom of each page to feed into a yearly tracker. I want to have a formula that scans a selected area for keywords. When it finds a keywords, it will return the value of the neighboring cell and total it (I just need a total, I don't need to have a list of all instances it finds). Depending on the keyword, income or expense, it will return the value of the cell directly to the left or the right.

    So it will scan a range of cells for say GAS, I only filled up twice this month, at $40 the first time and $50 the second time, when it finds gas it will then total up the neighboring cells so the formula at the bottom of the sheet will have $90 GAS.

    So the layout looks something like this;
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,319

    Re: Track Values in a Cell with a Neighbor Cell Containing Specific Keywords, how?

    Think you might be looking for SUMIF/SUMIFS.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. dynamic suggestion with auto populate neighbor cell
    By 123789456 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2017, 09:58 AM
  2. [SOLVED] Cell summing through referencing neighbor cell contents
    By metalray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2014, 09:08 AM
  3. IF a cell is Y, subtracting it's neighbor cell from a separate value.
    By lilli_ann in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2013, 02:24 PM
  4. Replies: 1
    Last Post: 09-28-2011, 03:57 PM
  5. How to keep track of high & low values of a cell?
    By Barcode in forum Excel General
    Replies: 4
    Last Post: 01-28-2010, 01:35 PM
  6. Disabling a cell if it's neighbor has a certain value
    By ysbn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2007, 03:42 AM
  7. Copy cells to neighbor column after leaving the cell
    By nemadrias in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2006, 08:25 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