Formula to Find combined cell total if criteria is met.

Hello, Please Help!!

I am working on a metrics sheet from an onboarding sheet. I am trying to find the total of FTE for each department.

I have a column called "FTE" which has various numbers in over 200 cells (e.g. 1, 0.78, 0.25 etc.) and i have a column called "Department" which has 5 service areas within the organisation.

What i want to find is like the below:

If the Department is "Community Services" then calculate the combined total of FTE.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!