Results 1 to 4 of 4

Thread: Adding values less than zero

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Adding values less than zero

    I would like to add values in col J than are less than zero where the ref in Col D is "GEN"

    Your assistance in this regard is most appreciated
    Attached Files Attached Files

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Give this formula a try...

    =SUMPRODUCT((D2: D13="GEN")*(J2:J13<0)*J2:J13)

    Change the ranges as needed, but make sure each range spans the same number of cells.

    EDIT NOTE: Remove the space between the colon and D13... without it, the "colon D" gets replaced with a smiley emoticon.
    Last edited by Rick Rothstein; 07-12-2012 at 12:55 PM.

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    You could also try SUMIFS

    =SUMIFS(J2:J13,D2: D13,"GEN",J2:J13,"<0")
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  4. #4
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13
    Thanks for the help, much appreciated

Similar Threads

  1. Replies: 2
    Last Post: 06-08-2013, 09:32 PM
  2. Vlookup Multiple Values By Adding Formula With Loop In VBA
    By Safal Shrestha in forum Excel Help
    Replies: 15
    Last Post: 04-22-2013, 04:49 PM
  3. Adding charts via code to a protected sheet
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 11-14-2012, 05:11 PM
  4. Adding Scroll bar to image box in vba
    By princ_wns in forum Excel Help
    Replies: 1
    Last Post: 12-13-2011, 09:47 PM
  5. Adding A Menu Bar To A User Form
    By Rasm in forum Excel Help
    Replies: 14
    Last Post: 05-05-2011, 04:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •