SUMIF Not Equal To Formula

gwen.pino78261

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)

Andrée Starå

Hi Gwen,

Try something like this. 

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

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

gwen.pino78261

It does.....thanks...You too

Andrée Starå

Excellent!

Happy to help!