Best Practice for a Needed Formula

Olivia Doiron

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])

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.