On the ClientDept worksheet put cursor in cell C16 → use from Home tab autosum to total clients served, you can also use the shortcut ALT=
On the ClientDept worksheet put cursor in cell C19 → select insert function (fx) from formula bar → select function SUMIF from drop down menu → select range as B2:B15, criteria as ER, and sum_range as C2:C15
On the ClientDept worksheet put cursor in cell C20 → insert function (fx) from formula bar → select function SUMIF from drop down menu → select range as B2:B15, criteria as OR, and sum_range as C2:C15
On the ClientDept worksheet put cursor in cell C23→ insert function (fx) from formula bar → select function COUNTIF from drop down menu → select range as B2:B15, and criteria as ER
On the ClientDept worksheet put cursor in cell C24→ insert function (fx) from formula bar, select function SUMIF from drop down menu → select range as B2:B15, and criteria as OR
Edit the preexisting SUMIF function to include the full range (B2:B15)
Edit the preexisting COUNTIF function to include the full range (B2:B15)