sum IF formula



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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!