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
Bookmarks