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

Amanda Hume
Amanda Hume ✭✭
edited 02/04/21 in Formulas and Functions

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!