Help with formula please

I am trying to sum "Echo Specific CME" that fall between the dates of 5/1/2018 to 4/30/2021 on column "Date of CME". I keep getting an "Unparseable" error. Please let me know what I am doing wrong...

My formula: =SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME] >=(DATE(2018, 5, 1), OR([Date of CME]:[Date of CME] <=(DATE(2021, 4, 30)))

Thanks,

Roseanne

Find more posts tagged with

Accepted answers

John Jonassen

Just missing a couple of commas. I think you were trying to use the OR for the between the two dates, however you are really wanting an AND which is automatically built in to the SUMIFS function. Give this a shot.

=SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME], >=DATE(2018, 5, 1), [Date of CME]:[Date of CME], <=DATE(2021, 4, 30))

All comments

John Jonassen

=SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME], >=DATE(2018, 5, 1), [Date of CME]:[Date of CME], <=DATE(2021, 4, 30))

Roseanne Gerringer

That worked! How would you get it to display 0.00 if staff member has no CME during that period?

Thanks,

Roseanne

John Jonassen

@Roseanne Gerringer , It should equal to zero if there are no CME's populated within that timeframe.

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.