=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
Microsoft Excel lets you share your spreadsheets with others, but sometimes your co-workers might edit the wrong column by mistake. To avoid this, you can lock specific columns. In this guide, we’ll show you how…
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
How to protect and share your workbook? Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to…
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.