Friday, September 2, 2016

POST NR.4 Camila Moncayo von Hase, Felicitas de la Cruz, Gloria Jung

POST NUMBER 4


TEXT:
There are several  Count Functions in spreadsheet, but in this text we are only going to explain COUNT. This function counts every cells which has a numeric value in it. For example: you have 5 cells in a column, and 4 have a numeric value (two of them have a 3 in it) written in it and the last one has Truck 1 written in it.  The thing is, you only want to know how many cells with a number written in it are in the column. To do this  you start writing an equal sign in a empty cell, open brackets and select the range from where you want to count the cells, close the brackets, and the value should appear in the cell. But you can also just count specific values. So as always you write an equal sign and open brackets.Then you write the specific value that you want to know in how many cells it appears and close the brackets. Then the value should appear in the cell.

Wordcloud from Post Nr. 4





COUNT and COUNTBLANK syntax


AUDIO:



SCREENCAST:


No comments:

Post a Comment