Sumifs based on quarter and year

3wing
3wing ✭✭✭
edited 01/13/23 in Formulas and Functions

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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!