Syntax LEFT(Text, Number) Text (required) – This is the text string you want to return the left most characters from.Number (optional) – This is the number of characters you want returned. If no value is entered, only the first character will be returned. Example In this example we get the first few characters of a text string. Notice that negative numbers result in a #VALUE! error and non whole numbers are rounded down to the whole integer....

What Is The Name Box? The Name Box has several functions. It displays the address of the active cell.It displays the name of the cell, range or object selected if this has been named.It can be used to name a cell, range or object like a chart.It can be used to go to any address you type into it.It contains a drop down list of all named cells and ranges and can be used to go to any of them....

Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum.Range 1 (required) – This is the range to which the first criteria is applied.Criteria 1 (required) – This is the criteria Range 1 has to satisfy to be included in the sum.Range 2, Range 3,… (optional) – These are more criteria ranges that can be used.Criteria 2, Criteria 3,… (optional) – These are more criteria to which the associated range has to satisfy to be included in the sum....