SUMIFS Function Not Working

@khush_hello ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi Community!

Please see below screenshots, 1st image has the SUMIFS formulae and columns used to create this, and 2nd image is the output result "TotalVacationhoursScheduled". The problem is this SUMIFS is not working as it is not adding up the number of hours from "VacationCalculatedHours" column back to "TotalVacationhoursScheduled". The criteria range is "EmployeeNameList" and criteria is a cell value from the "EmployeeNameList" . The problem remains all through that coloumn. Existing numbers that are currently displayed are hand coded ("+<numeric value> as shown below:

{=SUMIFS(VacationCalculatedHours:VacationCalculatedHours, EmployeeNameList:EmployeeNameList, <EmployeeNameList>) +<numeric value>}


Appreciate assistance.




SUMIFS Formulae.jpg

SUMIFS Result_.jpg



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!