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.