If cell value in range = "THIS" then add up cell values in this range
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)
Help Article Resources
Check out the Formula Handbook template!