+ Reply to Thread
Results 1 to 3 of 3

need to populate cell with SUM of negative numbers from column of mixed neg and pos number

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011 (Mac)
    Posts
    1

    need to populate cell with SUM of negative numbers from column of mixed neg and pos number

    Hello everyone,

    Hoping someone can help me out with this... it's probably pretty simple for a lot of the pros on this board.

    I have a column in a budget spreadsheet in which the cells are formatted as currency. Some of the cells contain positive numbers, some contain negative numbers. What I'm hoping to do is have excel find all the negative numbers in that column, add them together and populate a cell in a different column with the result. Specifically, as an example, go through column J and find all neg numbers, SUM them and put the result in cell F70.

    Thanks in advance for any help you guys can offer. Much appreciated

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: need to populate cell with SUM of negative numbers from column of mixed neg and pos nu

    How about...

    =SUMIF(J1:J200,"<0")

    Also, depending on your entire requirements, you could look into a pivot table
    Last edited by jeffreybrown; 12-19-2012 at 08:15 PM.
    HTH
    Regards, Jeff

  3. #3
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: need to populate cell with SUM of negative numbers from column of mixed neg and pos nu

    cyberia, welcome to the forum.

    You can use SUMIF, with the condition less than zero, which logically will exclude 0 and positive numbers, summing only your negative numbers.

    Hope this helps.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

+ 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