**Question description:**

*This user has given permission to use the problem statement for this blog.*

i need a formula to give me a total of cells with data the ignore the data itself.... for example I have 20 cells with date, but within the range there are 5 cells with no data. I need formula that will tell me the end sum is 15 that way if I sort the data the total numbers of cells with data will not change

Solved by F. Y. in 9 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
04/04/2018 - 08:35

2010

User
04/04/2018 - 08:35

sorry its 2007

Excelchat Expert
04/04/2018 - 08:35

Hi welcome to Gotit

Excelchat Expert
04/04/2018 - 08:36

Please share your sheet

User
04/04/2018 - 08:36

its not on this comupter

Excelchat Expert
04/04/2018 - 08:36

Please provide example data

User
04/04/2018 - 08:37

i would need to know a total of cells used

Excelchat Expert
04/04/2018 - 08:38

Total cells used mean the cells which are having data yoou mean?

User
04/04/2018 - 08:38

correct

Excelchat Expert
04/04/2018 - 08:40

=COUNT(A1:A9)

Excelchat Expert
04/04/2018 - 08:41

use this its giving the count

Excelchat Expert
04/04/2018 - 08:41

of cells used

Excelchat Expert
04/04/2018 - 08:41

Hello

User
04/04/2018 - 08:41

im still here

Excelchat Expert
04/04/2018 - 08:42

Use count formula

Excelchat Expert
04/04/2018 - 08:42

it will return number of cells that are not empty

User
04/04/2018 - 08:43

so =COUNTBLANK can be used to count the cells not used?

Excelchat Expert
04/04/2018 - 08:43

yes

Excelchat Expert
04/04/2018 - 08:43

=COUNTBLANK(Range)

User
04/04/2018 - 08:44

thank you ... that helps.

Excelchat Expert
04/04/2018 - 08:44

If you use other than numbers then we have to use =COUNTA(range) to get number of cells used

Excelchat Expert
04/04/2018 - 08:44

Please end the session

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*