# Excel - IF Function Problem - Expert Solution

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
User 04/04/2018 - 08:36
its not on this comupter
Excelchat Expert 04/04/2018 - 08:36
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

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.