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

1. ## 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. ## 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. ## Re: SUMIFS but where one condition can be true and the other not

Ma nishma

Will do!

Toda roba Belinda

4. ## 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

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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