Category: Google Sheet Functions

In this lesson we will learn how the FILTER function works in Google Sheet. The FILTER function is used to get the extract from a …

The FLOOR function in Google Sheet rounds down any specific number to the nearest multiple of any given number. It works similar to the MROUND …

The CEILING function in Google sheet rounds up any specific number to the nearest multiple of any given number. It works similar to the MROUND …

The MROUND function in Google Sheet is used to round a number to it’s nearest specified multiple. =MROUND(number, multiple) Number – This is the number …

The INDIRECT function returns a valid reference  to a cell based on a given text string in both Excel & Google Sheet. INDIRECT function is …

In Google Sheet we can use RANDBETWEEN() function to generate the random number in a specified range. Like here in cell A2 we have used …

The COUNTA function is used to count the number of non-blank cells within a supplied range of cells or values in both Excel & Google …

The COUNTIFS function returns the count of the cells that meet a single or multiple criteria in the same or different ranges in both Excel …

The SUMIFS function returns the sum of the cells that meet a single or multiple criteria in the same or different ranges in both Excel …

SUMPRODUCT function is used when you want to first multiply two or more ranges or arrays together and then get its sum in both Excel …