=COUNT(value1,[value2],...)
value1 argument is used to give number value/ cell reference/ range for which count is required
[value2] argument is used to give another number value/ cell reference/ range
… means, we can add multiple values/ cell reference/ range by separating them with comma ( , )
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us
Watch: How to use TODAY & NOW Function in Excel? What is TODAY Function? The TODAY function in Excel returns the current date in a serial number format. Click here to Read full Tutorial What is…
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k