Please enable JavaScript.
Coggle requires JavaScript to display documents.
function (A Function is a predefined worksheet
formula (Saves time…
function
-
-
-
Syntax: SUM(range) or SUM(num1, num2, …) Can type into cell, use AutoSum toolbar button or function wizard
Use the COUNTIF Function
The COUNTIF function counts the number of values that meet a specified criteria: =COUNTIF(B5:B8, “H”)
-
-
Function Wizard
Function wizard: A short-cut to all the functions in excel (use fx toolbar button) that walks you through building a function
-
Sumif Function
Write a formula in cell C9, which can be copied down the column, to summarize the number of courses being taken by students in this college