Count the no of records

February 6th, 2013 by Leah Tan Leah Tan

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 Responses to “Count the no of records”

  1. admin admin Says:

    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


  2. Leah Tan Says:

    Happy Lunar New Year!

    Thank you….just what I needed!


Leave a Reply

You must be logged in to post a comment.