Simple functions
These simple functions you use them to count numbers only, all data and blanks. They are called COUNT, COUNTA and COUNTBLANK.
Count: you use it to count cells with numbers inside it. These numbers can be, not only simple numbers, also dates. What I mean with that is the day, the month and the year. With the date you can easily, click on a cell and change it to the date you want.
Counta: you do exactly the same process with the count function. There's one exception, if you want to put an invisible number in a blank cell, you put two quotes in. If you want to know which number is behind that blank cell, you just click on the cell and there you will see it.
Countblank: you use it to count the number of blank cells in a range of cells or column.
What one has to do with each function in excel in spreadsheet:
1. Insert = (equal sign)
2. Write name of the function(e.g:counta)
3. Put ( (bracket)
4. Select columns
5. Put (bracket)
World Cloud:
Video:
Interview:
No comments:
Post a Comment