Results 1 to 8 of 8

Sumproduct & Sumif formula to only add up values <0

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Sumproduct & Sumif formula to only add up values <0

    Hi there,

    I have the following formula:

    =SUMPRODUCT(SUMIF(Data!A:A,$G$4:$O$4,Data!G:G),$G5:$O5)
    I basically want this formula to do what it's currently doing, however only add up cells <0 only.

    The above formula is giving a cumalative total, so -20, -30, -50, 150 would = 50....I need it to show -100.

    Hope this makes sense. I can post my spreadsheet if not.

    Many thanks

    Sam
    Last edited by 3smees23; 05-21-2012 at 03:25 PM.

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