In Excel, the VLookup function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number . The syntax for the VLookup function is: VLookup( value , table_array, index_number, not_exact_match)
Count – Excel Function
In Excel, the Count function counts the number of cells that contain numbers as well as the number of arguments that contain numbers. The syntax for the Count function is: Count( argument1, argument2, … argument_n ) argument1, argument2, … argument_n
Countblank – Excel Function
In Excel, the CountBlank function counts the number of empty cells in a range. The syntax for the CountBlank function is: CountBlank( range ) range is the range of cells to count empty cells. Examples: Based on this table:
Countif – Excel Function
In Excel, the CountIf function counts the number of cells in a range, that meets a given criteria. The syntax for the CountIf function is: CountIf( range, criteria ) range is the range of cells that you want to count
Round – Excel Function
In Excel, the Round function returns a number rounded to a specified number of digits. The syntax for the Round function is: Round( number, digits) number is the number to round. digits is the number of digits to round the
Sumif – Excel Function
In Excel, the SumIf function adds all numbers in a range of cells, based on a given criteria. The syntax for the SumIf function is: SumIf( range, criteria, sum_range ) range is the range of cells that you want to