Google Sheets Functions: Math
Find the list of all Google Sheets function tutorials on the Functions page.
Math Functions
| CEILING | Rounds a number up. |
| COUNTBLANK | Returns the number of empty cells. |
| COUNTIF | Returns the number of cells that match a criterion. |
| COUNTIFS | Returns the number of cells that meet multiple criteria. |
| FLOOR | Rounds a number down. |
| MROUND | Rounds a number to the nearest multiple of another number. |
| RAND | Generates a random number. |
| RANDBETWEEN | Generates a random integer between two specified values, inclusive. |
| ROUND | Rounds a number. |
| SQRT | Calculates the square root of a number. |
| SUM | Calculates the sum of a range of numbers. |
| SUMIF | Calculates the sum based on a criterion. |
| SUMIFS | Calculates the sum based on multiple criteria. |