Using SUMIFS formula to add up certain date ranges

Options
✭✭

Hello, I am in need of a formula that will add up certain date ranges. With every project that is virtually supported, our potential cost savings is \$2200. Now, going off of the "Arrival Date" column, I want to add up the projects virtually supported based on quarters of the month. What SUMIFS formula would I use to accomplish this?

• ✭✭
Options
Options

Hi @joshspr

You can use a DATE Function in a formula to determine the start and end dates of your Quarter, and have those be criteria in a SUMIFS function.

For example:

=SUMIFS([Potential Cost Savings]:[Potential Cost Savings], [Arrival Date]:[Arrival Date], >=DATE(2023, 01, 01), [Arrival Date]:[Arrival Date], <=DATE(2023, 03, 31))

Then for Q2 you'd just need to swap out the months you're looking for:

=SUMIFS([Potential Cost Savings]:[Potential Cost Savings], [Arrival Date]:[Arrival Date], >=DATE(2023, 04, 01), [Arrival Date]:[Arrival Date], <=DATE(2023, 06, 30))

Cheers,

Genevieve

• ✭✭
Options

@Genevieve P. Bless you! Thank you so much.

Josh

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!