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

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭
    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:


  • Frank S.
    Frank S. ✭✭✭✭✭✭
    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. 😎

  • Tracy Ashton_Grewal
    Options

    This worked perfectly