Which Excel function counts the cells containing numbers in a selected range?

A. COUNTA

B. COUNTIF

C. SUM

D. COUNT

Explanation

The COUNT function counts cells that contain numbers. COUNTA counts non-empty cells, while COUNTIF counts cells that meet a condition.

Source

Microsoft Support — COUNT function

Answer verified on 2026-09-15

Found an error? Read our corrections policy and submit a sourced correction below. You can also share a useful explanation in your own words.

Discuss the answer or suggest a sourced correction
Thank you for contributing.
Your comment was submitted and will appear after editorial review.

Your email is used only for moderation and is never displayed. Spam, copied material and fabricated endorsements are rejected.