Count the no of records

What formula to apply to count the no of records in a column eg

No Dept1 Dept 2 Dept 3
1. AA
2. BB
3. CC
4. DD

Dept tot ## ## ##

2 thoughts on “Count the no of records”

  1. Assuming the data AA, BB, CC and DD are captured from cell A1 to A4, you can use the COUNTA formula to count how many non-blank cells there are in the range. The formula should be entered as

    =COUNTA(A1:A4)

Leave a Reply