News

COUNTA function with multiple criteria counts how many arguments are in the list of arguments. Learn how to use COUNTA function in Excel.
In the example, you would enter "=COUNTA (A1:E100,G1:G100,F1)" and press "Enter" to count non-blank cells in those ranges. Include the function in other calculations, if necessary.