Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Grammatical form for COUNT (value1, value2, ...)< br/> Which Value1, value2, ... for all types of data contained or referenced parameters (1 ~ 30), but only the number of types of data were counted. COUNT function, when the count would be the number of null values, logical values, dates or a few words on behalf of the calculation into account; but the wrong value or the other can not be converted into digital text were ignored. If the parameter is an array or reference, then the only statistics cited in the array or the number; array empty or the cell reference, logical values, text or error values will be ignored. If the logic of the value of statistics, text, or an error value function should be used COUNTA. Examples of the use of COUNT function, also cited the example of the function A with the use of COUNTA. The above cases are for example, to calculate the total number of judges involved in a score (by function COUNTA), as well as several judges have given an effective fraction (use function COUNT).
As the FREQUENCY function returns an array, the array formula must be based on the form of input. Grammatical form of FREQUENCY (data_array, bins_array) Data_array which is a array or a set of reference values, used to calculate the frequency. If data_array does not contain any value, FREQUENCY function to return an array of zero. Bins_array array or as a reference region of the array, set the frequency of data_array sub-point calculations. If bins_array does not contain any value, FREQUENCY function to return the number of elements data_array. FREQUENCY usage seems pretty complicated, but its very useful. For example, can calculate the different section of the distribution of wages, the age distribution of employees, students, such as the distribution of results. Specific examples here to explain the basic usage. A company to calculate the age distribution of the staff as an example. Exterior work are listed in the age of employees. These age of 28,25,31,21,44,33,22 and 35, respectively, into cells C4: C11. This column is age data_array. Bins_array is another age group used to interval-valued. In this case, bins_array is the C13: C16 cells, respectively, contain values of 25,30,35, and 40. Input function to an array of forms FREQUENCY, we can calculate the age of 25, 26 ~ 30 years old, 31 ~ 35 years old, 36 ~ 40-year-old and 40 years of age in the number of the interval. This case has chosen five vertical post adjacent cell, that is, enter the following array formula formula. Return number of elements in array than bins_array (array) of more than 1 number of elements. The fifth highest number of intervals greater than 1 that (40) Numerical (44) the number. FREQUENCY function ignore blank cells and text values. (= FREQUENCY (C4: C11, C13: C16)) equal to (2; 2; 2; 1; 1)
|
