Sumifs formula help please


Trying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts?

=SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true))

=SUMIFS({Team Range 9}, >0, {Team Range 8}, [\[Formula descriptor 2\]]@row)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!