SUMIFS with multiple criteria in multiple columns

Hi -

I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong - somewhere!)

=SUMIFS({Status}, "Project Completed", {Hours Saved}, {Date Completed}, >"01/01/ 2020", {Hours Saved})

Any assistance would be greatly appreciated.

Thank you,

Donna

Best Answer

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It is just a syntax issue. Try something like this...


    =SUMIFS({Hours Saved}, {Status}, "Project Completed", {Date Completed}, @cell > DATE(2020, 01, 01))

    thinkspi.com

  • Donna Claes
    Donna Claes ✭✭✭✭✭✭

    Thank you for your help! This is driving me nuts! Is this part @cell > DATE(2020, 01, 01) to be written exactly as is, or does @cell refer to a specific field? Written as is I'm still getting an #UNPARSEABLE error.

  • Donna Claes
    Donna Claes ✭✭✭✭✭✭

    Your solution fixed it!! I had one to many parentheses at the end. Thank you so much!!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️


    Those parenthesis can definitely be a pain sometimes.

    thinkspi.com