sum IF formula

Tammy Parker

Hello

Me again... sorry.. I need to summarize total number of employees across the country by location.

I have column with location names, and a column with total number of employees...

For example I need to know for ALL locations how many employees are Remote

I tried

=sumif([Location (for summary)]1:[Location (for summary)]204,=Remote,[Number of Employees]1:[Number of Employees]204)

I am missing something.... please help...

Paul Newcome

Your formula should work if you wrap Remote in quotes.

"Remote"

Paul Newcome

Your formula should work if you wrap Remote in quotes.

"Remote"

Tammy Parker

Dang!! I was so close... LOL Thank you sooo much!! worked!

Paul Newcome

Happy to help!👍️

Tammy Parker

One more question...

What if I want it to be only part of what is in the cell... I have multiple locations in some cities, but I want all of Dallas,

How do I change from ="remote" to CONTAINS "Dallas"

Tammy Parker

@Paul Newcome

Paul Newcome

You would remove

= "Remote"

and replace it with

CONTAINS("Dallas", @cell)