If cell value in range = "THIS" then add up cell values in this range

Hi there

Trying to figure out how to write the following formula.

I want a sum of total hours in column "total hours" where the value in another column "TYPE" equals a specific value from the drop down menu.

So in non-formula speak, this is what I want:

If the TYPE (Column name) of group is "all employees" (drop down menu choice), then show sum the "total hours" (this is a number in the cell) allocated in the TOTAL HOURS column for this group.

UPDATED: Found the solution :

Thank you @Genevieve P

SUMIF(ASSIGNED:ASSIGNED, HAS(@cell, "Contact Name"), DURATION:DURATION)

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Amanda Hume

I hope you're well and safe!

Glad you got it working!

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Amanda Hume

Happy to help, without even knowing it! Amazing. HAS is a great little function.

Let us know if you have any other questions.

Cheers!

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.