Use COUNTA to count cells that aren't blank - Microsoft Support
View an example of how to use the COUNTA function to count cells that are not empty in a range of data.
COUNTA function - Microsoft Support
This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel. The COUNTA function counts the number of cells that are not empty in a range. COUNTA (value1, [value2], ...) The COUNTA function syntax has the following arguments: value1 Required. The first argument representing the values that you want to count.
Create conditional formulas - Microsoft Support
Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check.
Overview of formulas in Excel - Microsoft Support
Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Add, change, or remove error bars in a chart - Microsoft Support
Error bars in charts you create can help you see margins of error and standard deviations at a glance. They can be shown on all data points or data markers in a data series as a standard error amount, a percentage, or a standard deviation. You can set your own values to display the exact error amounts you want.