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:
    February 7th, 2013 at 12:17 am

    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)

  2. Leah Tan Says:
    February 13th, 2013 at 11:47 am

    Happy Lunar New Year!

    Thank you….just what I needed!

    Regards
    Leah

Leave a Reply

You must be logged in to post a comment.

s2Member®