Unfortunately for many, Microsoft Excel and Google Spreadsheets are two applications used daily in millions of workplaces. People who use these tools to manage data or information understand their work, while the rest of the population does not have this pleasure.
Of course, we have taken upon ourselves the task of teaching the basic and not very variants of these two programs. The one you touched on today is quite simple and useful for everyday situations, i.e. we will see how to count how many cells are filled in excel and google spreadsheets.
To get started, the first thing to do is open the spreadsheet in Microsoft Excel or Google Spreadsheets, as the system is the same in both cases. This sheet may or may not have data, in our case we entered a series of random values in columns A, B and C, reaching row number 11..
We know that all of these spaces have values except for B8 and C4, so the total result it should give us is 31.. This is the number of cells filled with any content type or values. How are we going to make Excel or Google spreadsheets do the calculations automatically?
The procedure is quite simple and all you have to do is enter in the formula section of Excel and Google Spreadsheets the following “=COUNTA(A1:C11)”. Of course, the quotes must be omitted and the values ”A1″ and “C11” are the ones we used in this example, in your case you must specify the start and end value you consider.
By doing this and selecting the box to display the result, it will appear and as you can see in the photo it is 31 which is the correct value for this account.. The truth is that there is not much complexity in it, and the truth is that it is a very good utility when you need to find out the number of cells filled with numbers.
Having done all this, there would be nothing to do, although this is interesting in that the number of elements that you want to count can be grouped by rows and columns and, therefore, it is not necessary to always count all the elements. that are present in the document.
Source: Computer Hoy
I am Bret Jackson, a professional journalist and author for Gadget Onus, where I specialize in writing about the gaming industry. With over 6 years of experience in my field, I have built up an extensive portfolio that ranges from reviews to interviews with top figures within the industry. My work has been featured on various news sites, providing readers with insightful analysis regarding the current state of gaming culture.
