Formulas

When working in Google Sheets there may be times when you want to find the median value of cells that meet certain criteria. This can be done by combining the …

Google Sheets has many useful functions for making statistical calculations. One such function is the Z.TEST function, which will return a one-tailed P-value of a Z-test. In this tutorial, I …

If you want to sort a dataset, but only return a certain number of items in Google Sheets, the SORTN function will come in handy. Not many people are aware …

If you are working with a set of data in Google Sheets and you want to find the minimum value in a range of cells based on a set of …

There are a few useful functions in Google Sheets that you can use to return substrings from a specific string. One such function is the right function. Using this formula …

The RANK function will return the rank of values in a dataset in Google Sheets. In this tutorial, I will show you how to use the RANK function in Google …

If you need to quickly find the maximum value in a range of data based on certain criteria, the MAXIFS function will come in handy. In this tutorial, I will …

There are a lot of tricks you can use in Google Sheets to speed up your productivity. Learning how to use Google Sheets properly will save you a lot of …

If you are working with dates in Google Sheets and only want to use the month of the year that date falls on, the MONTH function is a useful formula …

If you want to combine text together from different strings in Google Sheets with a specific separator, the TEXTJOIN function will come in handy. In this tutorial, I will show …