SUM and SUMIF Formula

Alisia Gill

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

Andrée Starå

Hi Alisia,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alisia Gill

I was able to figure it out, thank you for your response.

Andrée Starå

Excellent!

Happy to help!

Please share (if you'd like) the solution here so others with the same problem can find a solution.

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!