0
0
Excelspreadsheet~10 mins

COUNT and COUNTA functions in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows numbers and text values in columns A and B, with some empty cells.

CellValue
A110
A220
A3Text
A4
A530
B1Apple
B2Banana
B3
B440
B550
Formula Trace
=COUNT(A1:A5)
Step 1: COUNT(10, 20, "Text", "", 30)
Cell Reference Map
    A    B
1 | 10 | Apple  
2 | 20 | Banana 
3 |Text|        
4 |    | 40     
5 | 30 | 50     

Formula references A1 to A5 cells.
The formula COUNT(A1:A5) uses cells A1 through A5 which contain numbers, text, and empty cells.
Result
    A    B    C
1 | 10 | Apple |   
2 | 20 | Banana|   
3 |Text|       |   
4 |    | 40    |   
5 | 30 | 50    |   
6 |     |       | 3 

Cell C6 shows the result of COUNT(A1:A5) which is 3.
The result 3 appears in cell C6, showing the count of numeric values in A1:A5.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does COUNT(A1:A5) count in this data?
ANumbers and text
BOnly numbers
COnly text
DEmpty cells
Key Result
COUNT counts only numeric values in a range; COUNTA counts all non-empty cells including text.