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 ## ## ##
Leave a Reply
You must be logged in to post a comment.
Share on Facebook Tweet (Share on Twitter) Share on Linkedin Share on Google+ Pin it (Share on Pinterest)
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