In this article, you will learn how to use the COUNT formula in Excel.
The COUNT formula in Excel counts the number of cells in a range that contain numbers.
You can use the COUNT function to count the number of cells containing numeric values in your dataset, especially when its data amount is significant. Examples include:
The general syntax for using the COUNT function in Excel is as follows:
In this formula, the "value" argument(s) is the range of cells you want to count. You can input up to 255 arguments.
Note 1: Although you can refer to a range containing different types of values in the “value” argument, the formula only counts numeric values (incl. dates) but ignores empty cells, logical values, text, or error values in the referenced field.
Note 2: If you want to count the number of cells containing value types that the COUNT can’t count up, you can use the COUNTA formula instead.
Note 3: If you need to count the number of cells that meets one or more conditions, insert the COUNTIF or COUNTIFS functions.
Assume you have the following transaction list in the picture, which contains five transactions, and want to know the number of completed transactions by counting the number of final deal values input in the list. Three of the five transactions show their final deal values, whereas the other two projects have an “N/A” value.
You can use the following formula to check the number of numeric values in the range:
This function will count the number of cells in the range C3:C7 that contain numbers and returns 3 as there are three numeric values in the range (100, 300, and 500).
Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇