Discussion
In MS Excel, which function would you use to count only the cells in a range that contain numbers?
Answer: C
Correct answer: COUNT
COUNT counts numeric entries only, ignoring text, logical values and empty cells. Dates are counted, since Excel stores them as numbers. The family is worth learning together, because the differences are exactly what is examined. COUNTA counts every non-empty cell whatever it holds, including text and error values - and including a cell containing an empty string returned by a formula, which looks blank but is not. COUNTBLANK counts genuinely empty cells. COUNTIF and COUNTIFS count those meeting one or more conditions. A practical use of the distinction: comparing COUNTA with COUNT on the same column reveals how many entries are text rather than numbers - the usual explanation for a SUM that comes out lower than expected, since SUM ignores numbers stored as text. Text to Columns, or multiplying by 1, converts them.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development