+ Reply to Thread
Results 1 to 4 of 4

SUMIFS but where one condition can be true and the other not

  1. #1
    Registered User
    Join Date
    05-22-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    5

    SUMIFS but where one condition can be true and the other not

    Hi all

    I have a formula that I need to do the following:

    Sum all values in F where the value in H is "IX", but not if B is 2019/2020 AND C is Spring (but sum everything else)
    Do sum every other year with Spring and Autumn including 2019/2020 AND Autumn (but not 2019/2020 AND Spring).


    =SUMIFS(Master!$F:$F, Master!$H:$H,"IX",Master!$B:$B, "2019/2020", Master!$C:$C, "Spring")

    Any assistance appreciated.

    Regards

    Drazil

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: SUMIFS but where one condition can be true and the other not

    Hi,

    Sumif wont fit here.

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    05-22-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    5

    Re: SUMIFS but where one condition can be true and the other not

    Ma nishma

    Will do!

    Toda roba Belinda

  4. #4
    Registered User
    Join Date
    05-22-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    5

    Re: SUMIFS but where one condition can be true and the other not

    Hi all

    It the attached example, N2 is showing the value in F5 as 5 because of IX in H5. I want it to do that opposite.

    I want it to not count F5's value in 201920 for Spring (it is still valid) but instead H5 should show 10 because of the IXs in H18 and H20 (as they have expired).

    Many thanks

    Drazil

+ 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. Sumifs if one value is true
    By Mjoyce1994 in forum Excel General
    Replies: 5
    Last Post: 09-30-2019, 01:19 PM
  2. IF condition after the IF before is true ?
    By karmapala in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-30-2019, 05:13 AM
  3. Help popup window if condition is TRUE in change event if conditon is true
    By fanku in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2014, 12:46 PM
  4. Replies: 3
    Last Post: 02-02-2014, 04:26 AM
  5. [SOLVED] How to sum cel if condition is true
    By CarlosVA in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 04:24 PM
  6. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  7. TRUE condition???
    By pmguerra in forum Excel General
    Replies: 2
    Last Post: 06-05-2006, 11:35 AM

Tags for this Thread

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