The COUNT function counts all of the cells in a range with numeric values. The COUNTA functions counts all nonblank cells in a range.
To use the COUNT function:
Enter the formula =COUNT(range), where range is any range. This returns the number of numeric values in the range.
To use the COUNTA function:
Enter the formula =COUNTA(range), where range is any range. This returns the number of nonblank cells in the range.
For example, if cells A1, A2, and A3 contain Month, 1, and 2, respectively, then =COUNT(A1:A3) returns 2, whereas =COUNTA(A1:A3) returns 3.
Try it! Use the COUNT and COUNTA functions to fill in cells E1 and E2. Note that there are students below the visible portion of the spreadsheet.
Dostları ilə paylaş: |
