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
Vlookup – Excel Function
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)