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”
Leave a Reply
You must be logged in to post a comment.
Solve practical Excel problems for business
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.
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