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 ## ## ##
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 ## ## ##
You must be logged in to post a comment.
2 replies to "Count the no of records"
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)
Happy Lunar New Year!
Thank you….just what I needed!
Regards
Leah