SUMIFS with multiple criteria in multiple columns

Donna Claes · 01/31/20

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

Paul Newcome · 01/31/20

It should be written as is. Can you copy/paste the formula directly from your sheet? You should not be receiving the #UNPARSEABLE error.

Paul Newcome · 01/31/20

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

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

Donna Claes · 01/31/20

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.

Paul Newcome · 01/31/20

It should be written as is. Can you copy/paste the formula directly from your sheet? You should not be receiving the #UNPARSEABLE error.

Donna Claes · 01/31/20

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

Paul Newcome · 01/31/20

Happy to help! 👍️

Those parenthesis can definitely be a pain sometimes.

SUMIFS with multiple criteria in multiple columns

Best Answer

Answers

Help Article Resources

Categories