+ Reply to Thread
Results 1 to 3 of 3

Help with HLOOKUP or SUMIF? to separate negatives or numbers with a - symbol and add them

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    3

    Help with HLOOKUP or SUMIF? to separate negatives or numbers with a - symbol and add them

    I will bet that this answer is going to be so easy I will probably want to slap myself. I just need to pull out and then add up all of the - numbers in the row. Column D of the attachment is just a basic SUM. Im having trouble pulling out and adding the negative numbers and displaying the total in the waste column. Any help in this simple matter is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,433

    Re: Help with HLOOKUP or SUMIF? to separate negatives or numbers with a - symbol and add t

    Put this in E5:

    =SUMIF(F5:Q5,"<0")

    Adjust the range to suit (I can't see from the PDF file how many columns you are using), then copy down.

    Next time attach an Excel workbook rather than a PDF file.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-05-2014
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    3

    Re: Help with HLOOKUP or SUMIF? to separate negatives or numbers with a - symbol and add t

    It did. Thank You.

+ 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: 03-16-2025, 01:59 AM
  2. Vlookup & Hlookup combining separate workboo
    By Amak30 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2010, 10:28 AM
  3. Trying to add a column of numbers, but ignoring negatives
    By Lord Waste in forum Excel General
    Replies: 5
    Last Post: 04-07-2009, 06:43 AM
  4. VLookup and Hlookup combined using separate workbooks
    By trentonm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2008, 03:18 PM
  5. making columns automatically turn numbers into negatives
    By Kathy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-01-2005, 02:06 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