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 …
Category archives: Excel Resources
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”
Excel VLOOKUP Function
What does it do? The Excel 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 Lookup_value: This is …
Excel SUMIFS Function
What does it do? The Excel 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 <, >, <>, …
Excel SUMIF Function
What does it do? The Excel 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 <, >, <>, = for …
Excel SUM Function
What does it do? The Excel 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 sum …