I need your calculation support

Tracy Ashton_Grewal

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

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:

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