SUMIF FORMULA HELP

I don’t think you need the and functions, instead just separate them with commas. The reason why you are getting incorrect argument is because you aren’t giving the ifs statement a date column to check. The formula for checking date appears to be correct though

im assuming you would like to check the data for January of 2023?

Ed Gadd

Hi @SteyJ ,

Thanks for your help

Yes for this example I'd like to check January 2023

I've removed the AND

=SUMIFS({Tracker COST BENEFIT}, {Tracker STATUS}, "closed", (IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))

Still not quite working #unparseable. I feel its just a comma or bracket in the wrong place?

SteyJ

https://community.smartsheet.com/discussion/comment/410047#Comment_410047

After “closed”, add the {date column} use the same sheet reference for checking the year.

sumifs takes a range then criteria, so you just need to add the criteria for date

it would look like this

=SUMIFS({Tracker COST BENEFIT}, {Tracker STATUS}, "closed",
{Date}, IFERROR(MONTH(@cell), 0) = 1, {Date},  IFERROR(YEAR(@cell), 0) = 2023)

Ed Gadd

@SteyJ

Thanks for all the support today. I reference the date column but still no success. Any thoughts?

=SUMIFS({Tracker COST BENEFIT}, {Tracker STATUS}, "closed", {Tracker ECD}, (IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))

SteyJ

Make sure you are enclosing your IFERROR properly. Try this:

=SUMIFS({Tracker COST BENEFIT}, {Tracker STATUS}, "closed",
{Tracker ECD}, IFERROR(MONTH(@cell), 0) = 1, {Tracker ECD},  IFERROR(YEAR(@cell), 0) = 2023)

Ed Gadd

@SteyJ ,

Amazing, thankyou so much. Works brilliantly. Great education this afternoon too. Many many thanks

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.