SUM and SUMIF Formula

Can anyone help me. I have multiple offices located in different regions (Central, Northwest, Northeast). I need to get the sum of patients seen in each region and place into a dashboard.

Example:

Central has 4 offices;1 office saw 5 patient,s 1 office saw 0 patients, 1 office saw 25 patients, 2 office saw 6 patients. I need the sum of these offices to place into a dashboard by County

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!