How To Count a Number of Label/Name in Excel

Excel is an office application which is used to tabulate numeric data or the other. Excel is not just a calculation operation data, not only addition, subtraction, multiplication, or division, but also can perform calculations sorting (sorting), the determination of the amount of certain items, calculations with certain conditions, and much more. Well, now that would be given here is how to calculate the data of the same name in the data range is quite large. Exemplified here will count the same code for the data that is not too much.

When there are two names in large numbers, as shown below:

infositeplus.blogspot.com

infositeplus.blogspot.com

For example, to calculate the amount of data / item with the name I020 of the number of item 20 (Fig. 1, far left), then click on the column you want to display numbers (Figure 2, next to the column 1020), then type the function:

=COUNTIF(RANGE,CRITERIA) --> Formula

the standard operation should be :

=COUNTIF(F5:F24,"1020")

Range => shows range of columns and rows that contain such data, in this case, the data contained in the range of column and row F-5, to the range column and row F-24.

Then the resulting data "I020" of many data has 7. When you want to prove, just try it yourself manually counted, can make an example that displays the data are not too many.

Good Luck

(infositeplus.blogspot.com)