What does it do? The Google Sheets COUNTBLANK function very simply counts the number of empty cells in a range. Empty cells are literally cells with nothing in them. It’s worth noting an empty output from a formula in a cell will also be counted as BLANK. Syntax Explained Value1: This is the range of …
Category archives: Google Functions
Google Sheets COUNTA Function
What does it do? The Google Sheets COUNTA function very simply counts the number of cells in a range that are not empty. The cell(s) can contain numbers, text by direct input or generated by logical formulation. A formulated empty result (“”) would be deemed as not empty. Syntax Explained Value1: This is the first …
Google Sheets COUNT Function
What does it do? The Google Sheets COUNT function adds up the number of cells in a range that contain numbers as the cell value. This therefore means it does not count up cells that contain a text string. The values can be can be whole numbers, fractions, dates, percentages, time and currency amounts, see …
Google Sheets VLOOKUP Function
What does it do? The Google Sheets VLOOKUP function will search vertically, top to bottom, in the left most column of a range of cells to find a matching criterion, if found it will return the corresponding value from that same row and from a specified column within the same range. Syntax Explained Search_key: This …
Google Sheets SUMIFS Function
What does it do? The Google Sheets SUMIFS function adds numbers together in a range when matching evaluations are TRUE in multiple columns. The evaluations can use the logical expressions i.e. GREATER THAN, LESS THAN, NOT EQUAL TO, EQUAL TO, GREATER THAN or EQUAL TO, LESS THAN or EQUAL TO and EQUAL TO <, >, …
Google Sheets SUMIF Function
What does it do? The Google Sheets SUMIF function adds numbers together in a range when a matching evaluation is TRUE. The evaluations can use the logical expressions i.e. GREATER THAN, LESS THAN, NOT EQUAL TO, EQUAL TO, GREATER THAN or EQUAL TO, LESS THAN or EQUAL TO and EQUAL TO <, >, <>, = …
Google Sheets SUM Function
What does it do? The Google Sheet SUM function adds up numbers together from a range, this can be a group of cells, individual cells or numbers entered directly into the function. Numbers can be whole, fractions, time, dates, percentages and anything else stored as a number value directly into the cell. It can also …