Sumifs based on quarter and year

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)

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.