Help With SUMIFS Formula

Hello, I'm trying to retrieve SHIPPING COST for the current month of DATE REQUESTED for all repairs under ACTION TAKEN for the WARRANTY ACCOUNT “41130”. There are 4 different columns I’m trying to draw data from and I’m not too sure how to sequence the formula. All caps words are the columns I’m trying to include in the formula. This is what I currently have an am getting #INCORRECT ARGUMENT error.

=SUMIFS({RGA & Service Calls Shipping Costs}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {RGA & Service Calls Date}, {RGA & Service Calls Action Taken}, [Column2]13, {RGA & Service Calls Warranty Account}, "41130")

Find more posts tagged with

Formulas

Accepted answers

All comments

Nick Korna

Hi @Zhavion ,

It looks like your criteria ranges are not quite right and I'm not sure you need the IFERRORs thrown in there as well.

If Column 2 row 13 has the Action taken criteria you're looking for then I think this is about right (this is one bit I'm not sure on):

=SUMIFS({RGA & Service Calls Shipping Costs}, {RGA & Service Calls Date}, AND(MONTH(@cell) = MONTH(TODAY()), YEAR(@cell)) = YEAR(TODAY()))), {RGA & Service Calls Action Taken}, [Column2]13, {RGA & Service Calls Warranty Account}, "41130")

If you have any more details or some screen shots then these would help - if you need to blank out/hide other data then that's fine!

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.