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

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

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

All comments

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))

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.

Paul Newcome

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

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

Paul Newcome

Happy to help! 👍️

Those parenthesis can definitely be a pain sometimes.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.