sum IF formula

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...

Find more posts tagged with

Accepted answers

Your formula should work if you wrap Remote in quotes.

"Remote"

All comments

Your formula should work if you wrap Remote in quotes.

"Remote"

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

Happy to help!👍️

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"

You would remove

= "Remote"

and replace it with

CONTAINS("Dallas", @cell)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.