Excel provides many ways to count cells in a range that meet various criteria:
The DCOUNT function. The data must be set up in a table, and a separate criterion range is required.
The COUNT function. Simply counts the number of cells in a range that contain a number.
The COUNTA function. Counts the number of non-empty cells in a range.
The COUNTBLANK function. Counts the number of empty cells in a range.
The COUNTIF function. Very flexible, but often not quite flexible enough.
An array formula. Useful when the other techniques won't work.
Formula Examples
Listed below are some formula examples that demonstrate various counting techniques. These formula all use a range named data... See Spreadsheet Page Excel Tips: Cell Counting Techniques:
No comments:
Post a Comment