Sumifs formula help please

Tbech
✭✭✭
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
-
Try something like this...
=SUMIFS({Hours Column}, {Program Column}, "Program")
-
Perfect! Thanks!!
Answers
-
Try something like this...
=SUMIFS({Hours Column}, {Program Column}, "Program")
-
Perfect! Thanks!!
-
-
Hey Paul, what if "program" is blank.
-
On the source sheet or the sheet holding the formula?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!