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 …
Author archives: Pete
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 …
Excel MID Function
What does it do? The Excel MID function allows you to extract a portion of text from a text string contained in a single cell. By specifying the starting position and the length, you can extract any numbers of characters from within. In addition to letters and numbers, special characters (not limited to), asterisks, question …
Excel LEN Function
What does it do? The Excel LEN function returns the number of characters contained in a single cell. All characters are counted, this means, in addition to letters and numbers, special characters not limited to, asterisk, question marks, logical operators and also spaces, are included in the count. Like the Excel RIGHT and Excel LEFT …
Excel RIGHT Function
What does it do? The Excel RIGHT function extracts a number of characters from the right most side of a text string. The number should be a whole number and greater than zero. Spaces and special characters in the cell values are counted, but any cell formatting is excluded. In short, the cell value is …