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 …
Author archives: Pete
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 …