Question & Answer Count the no of recordsFebruary 6, 20132Comments 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 replies to "Count the no of records" admin February 7, 2013 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) Log in to Reply Leah Tan February 13, 2013 Happy Lunar New Year! Thank you….just what I needed! Regards Leah Log in to Reply Leave a Reply Cancel ReplyYou must be logged in to post a comment.