CODEWITHSUNDEEP
excel
Gokul Nath KP
Gokul Nath KP

Reputation: 15553

How to find the total number of records in Excel?

I have an excel sheet with below data:

Excel

How to find the Total Number of records automatically. That is, if we add another record, say "J" to the sheet, then Total Number of records must be automatically updated to 10.

I've tried using COUNT and COUNTA formulas. But there is no use. Any suggestions?

Upvotes: 0

Views: 2793

Answers (1)

Latheesan
Latheesan

Reputation: 24116

You need to combine COUNTA with COUNT like this:

=COUNTA(A3:A11)-COUNT(A3:A11)

enter image description here

  • COUNT – this Excel function returns the number of cells in a range that contain numbers
  • COUNTA – this function returns the number of cells that are not empty

We know that the number of cells that contain text (not numbers!) is equal to the number of non blank cells – the number of cells containing numbers. In other words: COUNTA – COUNT. Src: http://www.excel-2010.com/count-the-number-of-cells-with-text-in-excel/

Upvotes: 1

Related Questions