+ Reply to Thread
Results 1 to 3 of 3

Google Sheets: SUMIF for 2 negative conditions

  1. #1
    Registered User
    Join Date
    07-19-2021
    Location
    The Hague
    MS-Off Ver
    Google Docs
    Posts
    2

    Google Sheets: SUMIF for 2 negative conditions

    Hello,

    I'm working on dashboard that will calculate expected invoices from several clients based on their defined status.

    To calculate current expected invoices, I need to apply a SUM of all signed clients but exclude those that are labelled as "Churn" and "Hold"

    I thought on something like this: =SUMIF(14:14;OR("<>Churn";"<>Hold");13:13)

    Where in,
    row 14: I have the client status (Signed, Implementing, Hold, Churn, Invoiving, etc.).
    row 13: expected revenue from the client.

    For a simple negative condition, the formula is working but when I include the second condition through an OR function, I get 0 as the outcome.

    Any idea what am I missing here?

    Thanks!
    Last edited by polgomez; 07-19-2021 at 12:36 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Google Sheets: SUMIF for 2 negative conditions

    Try it with SUMIFS(). An example file would be helpful. See the yellow banner.
    Messages have been translated from Dutch to English by means of google translate.

  3. #3
    Registered User
    Join Date
    07-19-2021
    Location
    The Hague
    MS-Off Ver
    Google Docs
    Posts
    2

    Re: Google Sheets: SUMIF for 2 negative conditions

    Aye, completely forgot about SUMIFS()

    Thanks a lot!

+ 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. Google Sheets: Sumif returns 0?
    By toml90 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-28-2021, 08:34 PM
  2. Error Uploading to Google Drive with Sumproduct function (Sumif across multiple sheets)
    By Artie01 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-25-2021, 05:34 PM
  3. [SOLVED] Google Sheets: COUNTIFS and SUMIF formulas returning 0
    By algoit in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 01-23-2021, 03:28 AM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. Positive, negative, neutral numbers - conditional formatting (Google sheets)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-03-2018, 10:13 AM
  6. Google Sheets: Formula I can use with multi conditions
    By CullyM in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 07-12-2018, 01:06 PM
  7. SUMIF with different date formats (Google Sheets)
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 08-09-2014, 08:16 PM

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