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

      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)

    • Leah Tan

      Happy Lunar New Year!

      Thank you….just what I needed!

      Regards
      Leah

Leave a Reply