Google Sheets Functions

Google Sheets COUNTIF Function

This article will introduce you how to use the COUNTIF function in google sheets, and will show you a good example to better understand the usage of the COUNTIF function. Google Sheets COUNTIF Function Description The google sheets COUNTIF function is used to count the number of cells in a cell range that meet a… read more »

Google Sheets Rank Function

This article will introduce you how to use the RANK function in google sheets, and will show you a good example to better understand the usage of the RANK function. Google Sheets Rank Function Description The Google Sheets Rank function is used to return the ranking of a given number from a list. If there… read more »

Google Sheets MAX function

This post will guide you how to use Google Sheets MAX function with syntax and examples in Google Spreadsheet. Description The Google Sheets MAX function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array. The MAX function is a build-in function in Google Sheets and it is categorized… read more »

Google Sheets SUMIFS Function

This post will guide you how to use Google Sheets SUMIFS function with syntax and examples in Google Spreadsheet. Description The Google Sheets SUMIFS function sum the numbers in the range of cells that meet a single or multiple criteria that you specify. You can use the SUMIFS function to sum cells that based on… read more »

Google Sheets AVERAGEIFS Function

This post will guide you how to use Google Sheets AVERAGEIFS function with syntax and examples in Google Spreadsheet. Description The Google Sheets AVERAGEAIFS function returns the average of all numbers in a range of cells that meet multiple criteria. The AVERAGEIFS function is a build-in function in Google Sheets and it is categorized as a… read more »

Google Sheets AVERAGEIF Function

This post will guide you how to use Google Sheets AVERAGEIF function with syntax and examples in Google Spreadsheet. Description The Google Sheets AVERAGEIF function returns the average of all numbers in a range of cells that meet a given criteria. The AVERAGEIF function is a build-in function in Google Sheets and it is categorized as… read more »

Google Sheets SUBTOTAL Function

This post will guide you how to use Google Sheets SUBTOTAL function with syntax and examples in Google Spreadsheet. Description The Google Sheets SUBTOTAL function returns the subtotal of the numbers in a list or database. The SUBTOTAL function is a build-in function in Google Sheets and it is categorized as a Math and Trigonometry… read more »

Google Sheets MIN Function

This post will guide you how to use Google Sheets MIN function with syntax and examples in Google Spreadsheet. Description The Google Sheets MIN function returns the smallest numeric value from the numbers that you provided. Or returns the smallest value in the array. The MIN function is a build-in function in Google Sheets and it… read more »

Google Sheets LARGE Function

This post will guide you how to use Google Sheets LARGE function with syntax and examples in Google Spreadsheet. Description The Google Sheets LARGE function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array. It also can be used to get the nth largest value… read more »

Google Sheets COUNTA function

This post will guide you how to use Google Sheets COUNTA function with syntax and examples in Google Spreadsheet. Description The Google Sheets COUNTA function counts the number of cells that are not empty in a range. And it returns the number of non-blank cells within a range or values. It can be used to… read more »

Google Sheets MOD Function

This post will guide you how to use Google Sheets MOD function with syntax and examples in Google Spreadsheets. Description The Google Sheets MOD function returns the remainder of two numbers after division. So you can use the MOD function to get the remainder after a number is divided by a divisor in Google Sheets…. read more »

Google Sheets COUNT Function

This post will guide you how to use Google Sheets COUNT function with syntax and examples in Google Spreadsheets. Description The Google Sheets COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. It returns a numeric value that indicate the number of cells that contain numbers… read more »

Google Sheets AVERAGE Function

This post will guide you how to use Google Sheets AVERAGE function with syntax and examples in Google Spreadsheets. Description The Google Sheets AVERAGE function returns the average of the numbers that you provided. The AVERAGE function is a build-in function in Google Sheets and it is categorized as a Statistical Function. Syntax The syntax of… read more »

Google Sheets COUNTIFS Function

This post will teach you how to use Google Sheets COUNTIFS function with syntax and examples in Google Spreadsheets. Description The Google Sheets COUNTIFS function returns the count of cells in a range that meet one or more criteria. It allows to use the criteria with the numeric value or text string, which may be… read more »

Google Sheets SUMPRODUCT Function

This post will guide you how to use Google Sheets SUMPRODUCT function with syntax and examples in Google Spreadsheets. Description The Google Sheets SUMPRODUCT function multiplies corresponding components in the given one or more arrays or ranges, and returns the sum of those products. And it returns a numeric value. The SUMPRODUCT function is a build-in… read more »

Google Sheets IF Function

This post will guide you how to use Google Sheets IF function with syntax and examples in Google Spreadsheets. Description The Google Sheets IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE. The IF function is a build-in function in… read more »

Google Sheets ISBLANK Function

This post will guide you how to use Google Sheets ISBLANK function with syntax and examples in Google Spreadsheets. Description The Google Sheets ISBLANK function returns TRUE if the value is blank or null. The ISBLANK function is a build-in function in Google Sheets and it is categorized as an Information Function. Syntax The syntax of… read more »

Google Sheets POWER function

This post will guide you how to use Google Sheets POWER function with syntax and examples in Google Spreadsheets. Description The Google Sheets POWER function returns the result of a number raised to a given power. So you can use the POWER function to calculate a given number raised to a supplied power in Google… read more »

Google Sheets PI function

This post will guide you how to use Google Sheets PI function with syntax and examples in Google Spreadsheets. Description The Google Sheets PI function returns the value of mathematical constant PI. The returned value is 3.14159265358979 and ti will accurate to 15 digits. The PI function is a build-in function in Google Spreadsheets and… read more »

Google Sheets RATE function

This post will guide you how to use Google Sheets RATE function with syntax and examples in google spreadsheet . Description The Google Sheets RATE function returns the interest rate per payment period of an annuity. The RATE function is a build-in function in Google Sheets and it is categorized as a Financial Function. Syntax… read more »

Sidebar