If you’ve ever wondered how to calculate how many cells are filled in Excel and Google spreadsheets, you’ve come to the right place because we’re going to teach you how to do it.
Unfortunately for many people, Microsoft Excel and Google Spreadsheets are two such applications that are used daily in millions of jobs. Those who use these tools for data or information management are well versed in their operations, while the rest of the population does not enjoy it.
Of course, we have entrusted ourselves with the task of teaching the basics, not the basic options for both these programs. The one you touched on today is quite simple and useful for everyday situations and, we are going to see how many cells are filled in Excel and Google spreadsheets.
To begin, first open a spreadsheet in Microsoft Excel or Google Spreadsheets, as the system is the same in both. This sheet may or may not contain data, in our case we entered a series of random values in columns A, B and C, leading up to row number 11.,
We know that there are values in all these places except b8 and c4, so the general result we have to give is 31, This is the number of cells that are filled with any type of content or value. How are we going to make excel or google spreadsheets calculate automatically?
The process is quite simple and all you have to do is type The following “=COUNTA(A1:C11)” in the Formulas section of an Excel and Google spreadsheet, Of course, the quotes should be omitted and the ‘a1’ and ‘c11’ values are the ones we used in this example, in your case you have to put the initial and last value that you assume.
After doing this and selecting a box to display the result, it will appear and as you can see in the picture it is 31, which is the correct value for this account, The truth is that it doesn’t have much complexity and in fact it is a very good utility when it comes to knowing the number of cells filled with numbers.
After doing all this, there will be nothing left to do, although this is interesting because the number of elements you want to count can be grouped by rows and columns and, therefore, there is no need to always count all the elements. . that are present in the document.