Welcome!

SUMIF Not Equal To Formula

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)

Formulas

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

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

Excellent!

Happy to help!

Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
Failed to Import (error)
I am trying to import (just blank rows, with 18 columns) from Excel into an existing sheet, so I don't have to recreate the 18 columns into my tracker. But I get a "Failed to Import" error. HELP!
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…