The COUNTA is a cell counting function, which counts all cells in a range that has values, both numbers and letters.
=COUNTA(value1,[value2],...)
The COUNTA function is used when we need to count Non-Blank cells in a selected range.
For example, for counting cells from A1-A10, the formula is “=COUNTA (A1:A10).”
The function also counts the number of value arguments provided. The value argument is a parameter that is neither a cell nor a range of cells.
Formula =COUNT(B1:C10)
The COUNT Function will count the number of cells with numeric values within the selected range B1 to C10.
FORMULA =COUNTA(B1:E10
The COUNTA Function will count the number of cells with numeric values and Alpha numeric values within the selected range B1 to E10
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
How to find duplicates in excel? Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to Find and…
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.
To subtract numbers in Excel, follow these steps:
Start by typing an equal sign (=) in the cell where you want the result.
Enter the first number or cell reference you want to subtract from.
Type a minus sign (-).
Enter the second number or cell reference you want to subtract.
This quick tutorial explains the basics of external references in Excel and shows how to reference another sheet or workbook in your formulas.
This tutorial shows how to quickly change CSV files into Excel in any version, from 365 to 2007, without common problems.
There are two main ways to move a CSV file to Excel: by opening it directly or by importing it as external data. This article gives step-by-step instructions for both methods, explains their pros and cons, and highlights potential problems with tips to fix them
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.