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

Amanda Hume

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)

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