How to Use the COUNTA function to count cells containing data
To count all cells that are not empty and contain data in a range or array, use the COUNTA function. Here is the syntax that is used.
COUNTA(value1, value2, …)
value1, value2, …: 1 to 30 arguments representing the values to be counted.
To count all cells containing data:
In cells A1:A10 type any kind of data (numeric and [...]
Use the SMALL function to find the smallest values in Excel
To determine the smallest value in a list, we can use the MIN function. However, the easiest way to find multiple small values of a range is by using the SMALL function. This function returns the nth smallest value in a set of data. Here is the syntax that is used for the SMALL Function:
SMALL(array, [...]
How to use the SUMPRODUCT function in a formula in Excel
The SUMPRODUCT Function is one of the most time saving functions in all of Excel especially when you have a boatload of data to work with. What it does is total the products returned by multiplying the values in corresponding arrays. For one array to correspond to another, each must consist of the same number [...]
