# I need your calculation support

Options

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

• ✭✭✭✭✭✭
Options

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:

• ✭✭✭✭✭✭
Options

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.

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

• Options

This worked perfectly