Sheet Summary Field Formula to Summarize Expenses in a Column by Year

I have a sheet that includes a column of net costs with a Year column. I want to create a sheet summary field with a formula that calculates the total net costs for a specific year (e.g., 2023).

I tried the following =SUMIFS(Revenue_Column, Year_Column, Year_Value) but kept getting an error, and I don't think it's accurate. Any help is greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

Matt Johnson

Hi @Tony Fronza

This formula should work =SUMIF(YEAR:YEAR, "2023", Revenue:Revenue)

In the YEAR column I have the formula =YEAR(Date@row) pointing at a Date column. This is sometimes helpful so you could do a report grouped by year and summarize the revenue.

Or you could do this without the YEAR helper column with this formula:

=SUMIFS(Revenue:Revenue, Date:Date, IFERROR(YEAR(@cell), 0) = 2023)

I hope that helps.

Matt

All comments

Matt Johnson

Hi @Tony Fronza

This formula should work =SUMIF(YEAR:YEAR, "2023", Revenue:Revenue)

In the YEAR column I have the formula =YEAR(Date@row) pointing at a Date column. This is sometimes helpful so you could do a report grouped by year and summarize the revenue.

Or you could do this without the YEAR helper column with this formula:

=SUMIFS(Revenue:Revenue, Date:Date, IFERROR(YEAR(@cell), 0) = 2023)

I hope that helps.

Matt

Tony Fronza

@Matt Johnson you da man! Thank you so much. This works perfectly.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.