Formula help to view a specific month

Hello,

I currently have the formula below. Curious if anybody could help me change the formula to be a specific month like July, June, September. Any help is appreciated

=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

I'm not sure I follow. Are you wanting to change the {Current month} to a specific month, or are you trying to search that range for a specific month?

Suzy Schreiber

Thanks for the help. Says unparseable, but I think I figured out a different way around it. Appreciate your time and answers.

All comments

Paul Newcome

I'm not sure I follow. Are you wanting to change the {Current month} to a specific month, or are you trying to search that range for a specific month?

Suzy Schreiber

Thanks Paul! to a specific month.

Paul Newcome

You are trying to change the data in the {Current Month} range to s specific month?

Suzy Schreiber

Yes. Sorry the formula right now is set to always look at the current months data. But i want to be able to have a new formula set so i can see a specific month. So instead of viewing August (current month) i would like to see July and June. Hope that is more clear. In any case thanks.

Paul Newcome

Oh. In that case you want to adjust your criteria and not the data within the range. To do that, you would change the criteria to the month number you want to search for.

=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, =MONTH($[Column9]$26))

For June:

=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, = 6)

For July:

=SUMIFS({Error Cost}, {Error Code}, $[Primary Column]@row, {Location}, [Column2]$1, {Current month}, = 7)

Suzy Schreiber

Thanks for the help. Says unparseable, but I think I figured out a different way around it. Appreciate your time and answers.

Paul Newcome

Are you able to copy/paste the exact formula that is causing the error directly from the sheet to here? The formula I provided shouldn't be throwing that error.

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.