00:00welcome back in this video i will guide you how to count cells with data in excel
00:04to count cells that contain data in excel you have a few different methods depending on what
00:09exactly you want to count the first method is the counter function that counts any cell that is not
00:16empty this includes text number error values and even cells containing spaces or formulas that
00:23returns or a blank string so formula is you need to click on the cell where you want the result
00:29to be
00:30appeared for example in the cells and then type equal sign type counter open the bracket and
00:40highlight the range of cells you want to check for example this one close the bracket and press enter
00:49this will give you the number of the cells in that range that have something in them and for example
00:55if you write something like fail and here you can see that so moreover in the second method if you
01:02only want to count cells that contain numerical values use the standard function for this you need to
01:09use the formula put the equal signs type count open the bracket and select the range
01:19of cells and close the bracket hit enter so you can see that this will return because it only counts
01:25the numbers and this cell has the tags so this way you can easily count cells with data in excel
01:32if
01:33you think this video is helpful please support my channel thanks for watching
Comments