Please enable JavaScript.
Coggle requires JavaScript to display documents.
Spreadsheets - Coggle Diagram
Spreadsheets
Functions
Statistical function
-
-
-
-
COUNTIF( <range of cells> , <condition> )
LARGE( <range of cells>, k )
SMALL( <range of cells>, k )
-
Mathematical functions
-
SUMIF( <cell range>, <criteria>, <sum range> )
-
-
-
-
-
Logical functions
-
AND( <condition1>, <condition2>, ... )
OR( <condition1>, <condition2>, ... )
-
Text, date and time functions
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-