How to add a value from any row that has column = May

This sheet (displayed to users as cards) moves projects to different months for capacity planning. We then have a header task for each month which we display the total job value currently assigned to the month.

This value is currently manually calculated.

How/can we have a formula in the header task that sums all the $ fields from rows that have the matching month value?

This way when we move the cards around the totals will update

Screenshot_20210514-194117_Smartsheet~2.jpg

Find more posts tagged with

Formulas

Card View

Accepted answers

Paul Newcome

You are going to want to use something along the lines of...

=SUMIFS([$ Column]:[$ Column], [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 5)

Doug M

@Paul Newcome thanks we worked it out starting from your formula, ended up with

=SUMIFS([Sale Price]:[Sale Price], [Month Name]:[Month Name], "May")

as didn't want to use the actual date just the name of the month

Thanks again!

All comments

Paul Newcome

You are going to want to use something along the lines of...

=SUMIFS([$ Column]:[$ Column], [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 5)

Doug M

Hi Paul, thanks that works with the date column but I can't seem to get it to work by checking the Month column (May, June, July etc). Does this formula have to refer to a date field?

Paul Newcome

@Navroz Kajani Make sure that the Miro date column is set as a date type column and make sure the data in that cell is an actual date value.

Doug M

@Paul Newcome thanks we worked it out starting from your formula, ended up with

=SUMIFS([Sale Price]:[Sale Price], [Month Name]:[Month Name], "May")

as didn't want to use the actual date just the name of the month

Thanks again!

Paul Newcome

Happy to help. 👍️

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.