+ Reply to Thread
Results 1 to 4 of 4

If Text Entered In One Column, Sum Adjacent Column

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Terre Haute, IN
    MS-Off Ver
    Excel 2003
    Posts
    2

    If Text Entered In One Column, Sum Adjacent Column

    Hello - I have a sheet where one of my column is labeled Status and then I have another column for dollar amounts called Extended. What I am trying to do is check to see if any information at all (non blank) has been entered in the Status column, and if it has, then I want to sum only the Extended values that are adjacent to information in the Status column

    Ex.

    Status Extended
    A Keep $3000.00
    B Not Needed $2500.00
    C $1500.00
    D Keep $4000.00
    E $500.00

    Figure I am looking for Would Yield - $9500.00

    Thanks in advance for your help.

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: If Text Entered In One Column, Sum Adjacent Column

    Try this...
    =SUMIF(A2:A6,"<>"&"",B2:B6)

  3. #3
    Registered User
    Join Date
    08-26-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: If Text Entered In One Column, Sum Adjacent Column

    try this.......

    =SUMIF(A:A,"*",B:B)

  4. #4
    Registered User
    Join Date
    01-11-2013
    Location
    Terre Haute, IN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: If Text Entered In One Column, Sum Adjacent Column

    That worked, thank you very 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