I need your calculation support

I am trying to perform a sumif calculation.

=SUMIF([Actual Savings]:[Actual Savings], [Actual Savings Start Date]:[Actual Savings Start Date], AND(@cell < DATE(2023, 3, 31), @cell > DATE(2023, 3, 1)))

The first time it shows 0 as the value when it should be over 200K. The second time I typed in the exact same calculation it shows as #invlaid operation.

All I want to do is sum actual savings when the actual savings start date falls in March. Can someone help me.

Thanks

Find more posts tagged with

Accepted answers

All comments

Danielle Arteaga

See if this works for you:

=SUMIFS([Actual Savings]:[Actual Savings], [Actual Savings Start Date]:[Actual Savings Start Date], >DATE(2023, 3, 1), [Actual Savings Start Date]:[Actual Savings Start Date], <=DATE(2023, 3, 31))

This formula won't give you a "running" total but it will sum the actual savings amounts during the March date range. I tested using some sample data as below:

Screenshot 2023-04-12 at 10.34.30 AM.png

Frank S.

Greetings @Tracy Ashton_Grewal,

Here is another option:

=SUMIF([Actual Savings Start Date]:[Actual Savings Start Date], AND(@cell >=DATE(2023,3,1), @cell <=DATE(2023,3,31)), [Actual Savings]:[Actual Savings])

I hope this helps.

Tracy Ashton_Grewal

This worked perfectly

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.