+ Reply to Thread
Results 1 to 2 of 2

Formula to Add Values to Adjacent Text Columns

  1. #1
    Registered User
    Join Date
    08-26-2019
    Location
    Green Bay, Wisconsin
    MS-Off Ver
    2013
    Posts
    1

    Formula to Add Values to Adjacent Text Columns

    I have text in columns A, C, E, G and numbers in columns B, D, F, H
    I have used conditional formatting to identify duplicate words (in this case ERF).
    I need a formula to add the values in the columns adjacent to the word ERF. (B3, B4, D5, D6, F1, etc)

    A B C D E F G H
    1 VLF 10 CFC 25 ERF 3.85 0
    2 VLF 4 CFC 10 ERF 1.54 0
    3 ERF 2.4 SSU 8 TBS 0.04 VLF 3.2
    4 ERF 1.8 SSU 6 TBS 0.03 VLF 2.4
    5 VLF 0.84 ERF 0.6 0 0
    6 CFC 8 ERF 1.2 0 0
    7 CFC 3.5 PAS 1 VLF 0.75 ERF 0.5
    8 CFC 24 VLF 10 ERF 1.68 0

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Formula to Add Values to Adjacent Text Columns

    Hi,

    =SUMIF(A1:G8,"ERF",B1:H8)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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. [SOLVED] Almost There! Match values in two columns and return text in adjacent cell
    By mrkake in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-01-2016, 02:14 AM
  2. Look up values in 2 adjacent columns. Return values in 3 columns if match.
    By Gssoc777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2015, 12:28 PM
  3. [SOLVED] I need to fill 2 text columns based on criteria from 2 adjacent columns
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-04-2014, 02:55 PM
  4. Replies: 1
    Last Post: 03-09-2013, 02:55 PM
  5. Replies: 1
    Last Post: 02-18-2013, 01:46 AM
  6. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  7. Compare values in two columns and return text from adjacent cell
    By MrBorders in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2009, 04:54 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