Skip to main content

Library Workshops

Excel Intermediate - Learning Objective #3

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 C23insert 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 C24insert 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)

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback