Need Formula help

Hello,

I need a formula in order to calculate the sum of specific hours for a resource on a particular week with a certain criteria.

For example, I need the formula that calculates the hours for Jane Doe for week ending 4/2/21 charged only to Department A. I tried something with SUMIF or IF(SUMIFS but couldn't get it to work.

Any help is greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try something like this...

=SUMIFS(Hours:Hours, Department:Department, @cell = "Department A", [Week ending]:[Week ending], @cell = DATE(2021, 04, 02))

All comments

Paul Newcome

Try something like this...

=SUMIFS(Hours:Hours, Department:Department, @cell = "Department A", [Week ending]:[Week ending], @cell = DATE(2021, 04, 02))

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.