Best Practice for a Needed Formula

Good Morning!

I need calculate a sum for our total numbers based on our Fiscal Year. I am trying to find the best formula to accomplish that. I am not sure if a SUMIFS is the best way to accomplish this.

I need it to calculate based on the Current Date being greater than 10/3/24. I know what I have below is incorrect it has been awhile since I have written a formula. Any help would be appreciated. :)

=SUMIF([Current Date]:[Current Date], >10 / 3 / 24, [Total Pieces of Media]:[Total Pieces of Media])

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

Give this a try:

=SUMIF([Current Date]:[Current Date], @cell > DATE(2024, 3, 24), [Total Pieces of Media]:[Total Pieces of Media])

Olivia Doiron

THANK YOU THANK YOU! I wasn't sure how to incorporate the date! I made a couple adjustments and viola! :)

Carson Penticuff

I'm glad it worked… you already had the logic, just needed a bit of syntax.

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.