Sumifs based on quarter and year

3wing

We're creating a master project sheet. we'd like to be able to break out totals by yearly quarters. For example 1st quarter 2023. This is the formula I have working for 1st quarter total.

=SUMIFS(Fee:Fee, [Preferred Date]:[Preferred Date], INT((MONTH(@cell) + 2) / 3) = 1)

When I add a year criterion it fails - I imagine I have the second set of criterion not correct syntax-wise. Any help would be appreciated:

=SUMIFS(Fee:Fee, [Preferred Date]:[Preferred Date], INT((MONTH(@cell) + 2) / 3) = 1, YEAR(@cell) = 2023)

3wing

Anyone have a quick fix? Thanks

Paul Newcome

You would need to use the AND function to use two sets of criteria for the same range.

=SUMIFS(Fee:Fee, [Preferred Date]:[Preferred Date], AND(INT((MONTH(@cell) + 2) / 3) = 1, YEAR(@cell) = 2023))