Library Workshops

Excel Intermediate - Learning Objective #3:

Using numerical formulas:

Skills and concepts covered:

• AUTOSUM
• SUMIF
• COUNTIF

Activities:

• 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)