What does it do? The Excel LEFT function extracts a number of characters from the left 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 …
Author archives: Pete
Excel SEARCH Function
What does it do? The Excel SEARCH function allows you to find the starting position of a text string within another text string. The text string to search is NOT case sensitive, it can be one character in length, a word or words and you may use wildcard characters for partial matching. If found, it …
Excel FIND function
What does it do? The Excel FIND function allows you to find the starting position of a text string within another text string. The text string to find is case sensitive, it can be one character in length, a word or words, but you may NOT use wildcard characters. If found, it will return a …
Excel IFERROR Function
What does it do? The Excel IFERROR function evaluates a formula or cell reference and allows for one of two returns. Firstly, if there is no error, you will see the value from your formula or cell reference. Secondly, if there is an error, typically in the form of #N/A, #VALUE! or #DIV/0!, you can …
Excel IF Function
What does it do? The Excel IF function allows you to perform a logical test, if the result is true, it will return one result, opposingly, it will return another if it is found to be false. The logical test uses the logical expressions, GREATER THAN, LESS THAN, NOT EQUAL TO, EQUAL TO, GREATER THAN …
Excel COUNTIFS Function
What does it do? The Excel COUNTIFS function counts together the number of cells that meet a given criteria. Unlike COUNTIF which allows only one range and one criterion, COUNTIFS is able to check up to 127 ranges and 127 criteria. The criterion can be a text string, number or logical expression, i.e. GREATER THAN, …
Excel COUNTIF Function
What does it do? The Excel COUNTIF function counts together the number of cells that meet a given criterion. The criterion can be a text string, number or logical expression, i.e. GREATER THAN, LESS THAN, NOT EQUAL TO, EQUAL TO, GREATER THAN or EQUAL TO, LESS THAN or EQUAL TO and EQUAL TO. Expressions use …
Excel COUNTBLANK Function
What does it do? The Excel 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 Range: This is the range of cells …
Excel COUNTA Function
What does it do? The Excel 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 range …
How to Easily use the Excel COUNT Function
What does it do? The Excel 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 example …
Continue reading “How to Easily use the Excel COUNT Function”