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