SUMIF Not Equal To Formula

gwen.pino78261
gwen.pino78261 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am using this formula to Sum all values except for the ones assigned to "External"..It still adds these hours.  What did I miss? 

=SUMIF([Resource Type]:[Resource Type], "<> *External*", Hours:Hours)

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!